The Qlikview Bundle Load allows you to associate an image or sound with an actual field selection. As I mentioned above, this can be useful for aesthetics, adding a nice visual touch when a user selects a field value filter from a list box. In the example I’m going to show you below, I will demonstrate how to bring images for each NFL team into a Qlikview application, associating each with the selection of the team in a list box. The image will then appear in a Text Object, which dynamically changes based on the NFL team selected.
How to implement Qlikview Bundle Load
Setup a folder to store your images. In my example, I have created the folder “C:\NFL Images\”, and have placed all 32 of my image files into this location (I chose to use the JPEG image .jpg). Then, create an Excel file that looks like the following, and save it to the same location.
Now that your images and Excel file are setup and properly stored, you can bring these into the Qlikview application. Go into the Script and setup the following statement:
(ooxml, embedded labels, table is Sheet1);
Make sure the field names include an association to an existing table. In my case, I have “NFLTeam”, which will be associated to another table field. This is important so you can establish the association when a user selects this field value filter from a list box in the application. Once you have completed the script, RELOAD the application.
Now we are ready to display the images in a Text Object. First, setup the list box you would like the user to filter on. In my example, I have a list box setup for the field “NFLTeam”. Next to the list box, add a new Text Box object.
In the properties of the Text Object, within the General Tab, setup the following:
- Text: =info(NFLTeam)
- Representation: Select “Image” in the drop-down
- Background: Set to 100% Transparency
That should do it! When a user makes a selection in the list box for NFLTeam, the text object will now display the image you associated with the value for NFLTeam.
Select a different value for NFLTeam, like “PIT”, and you will dynamically see the image change:
As you can see, implementing a Bundle Load is not very difficult, once you have all the images organized and stored in the proper location. This is also a great way to add a nice visual touch to your Qlikview application.
There are a few practical uses for this functionality:
- Displaying the flag image for a given country or organization
- Associating a picture for a given person or employee
- Show the logo or image for a given sports franchise, like shown above
Given how easy it is to setup, I’m sure you can come up with many ways to implement this functionality.