Qlik Community

Qlik Design Blog

All about product and Qlik solutions: scripting, data modeling, visual design, extensions, best practices, etc.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
Charles_Bannon
Employee
Employee

As a QlikView developer I am often asked to load images into QlikView. In some instances the images are associated to other data fields and in other instances they are to be loaded in to the application to help convey a message. For example, let’s say that you need to bring in flags of countries that are to display when the corresponding country is selected and you need to display an icon that indicates whether sales for a country are above or below a predefined threshold. It sounds like an easy enough task; so how do you do it?

Well, QlikView offers the developer the Bundle function that can be added to the Load statement. Bundle Load statement allows the developer to load the image files directly into the QlikView application for portability.

The Bundle Process is a very simple scripting process. The syntax for the Bundle Load should look like this:

image1.png

The image file should contain two fields:

  • The first field is an identifier such as an index number, image name, a key field that associates the image back to other data files, etc.
  • The second field should contain the path to the image.

This file contains the CountryID so that I can associate the flags with the countries

image2.png

This file contains just an image name because I am just using these icons as a reference and they are not associated to any fields in other files.

image3.png

Once the images are loaded into QlikView we can now reference them using the INFO() function and a standard IF Statement:

image3a.png

I am using the INFO() function to display the flags so whenever a Country is Selected, QlikView will know to go grab the corresponding image based on the CountryID. If we needed to, we could do the same thing with the symbols by simply adding a list box for Image Name and selecting an image from there. For this example though, I am using a standard IF Statement to display the symbol for the country sales.

Here is what it looks like when the user selects a country. The Info() function displays the image associated with CountryID =1 and because Sales were above the threshold the green square is displayed.

image4.png

One note of caution, when images are loaded into a QlikView application using the Bundle Load statement, both the amount of RAM and the size of the application increase so consider both the size and the amount of image files before deciding to use the Bundle LOAD statement.

I wrote a technical brief that outlines these steps in more detail. You can access it here.

Happy Qliking!

28 Comments
qlikviewwizard
Master II
Master II

Good info. Thanks for sharing.

0 Likes
4,557 Views
Not applicable

Good Information.It Helps me a lot.And also Try This one....

Folder.jpg

0 Likes
4,557 Views
Not applicable

good information very usefull

0 Likes
4,557 Views
HirisH_V7
Master
Master

Hi,

Nice Post . please upload app and Docx . It will be help full cbo

Regards,

hirish

0 Likes
4,557 Views
Not applicable

Very helpfull, it works. Is there a way to change the size of the image, relative to an amount? thanks

0 Likes
4,586 Views
Not applicable

Can I load pictures from the web?

0 Likes
4,586 Views
bestofwest
Creator II
Creator II

Load our use?

0 Likes
4,586 Views
jwbadger3
Contributor II
Contributor II

I've built on this awesome resource from Chuck...

Bundle Load Images from a Filepath

In this scripting version, we create a little loop to read the filepath so that if the folder moves or the image names change, you don't need to maintain the excel sheet.

0 Likes
4,586 Views