How to use Info Load vs Bundle Load (QlikView)

Sonja_Bauernfeind — Thu, 21 Jan 2021 09:32:44 GMT

If you need Images in Qlikview you can read out a Dir with Images and store them into the QlikView Application.

For this you need the QlikView Function Info Load or Bundle Info Load.

Bundle

If a piece of external information, such as an image or a sound is to be connected to a field value, this can be done via a table that is loaded with the info prefix . If you want to include the external files into the qvw itself, e.g for portability reasons, you may use the bundle prefix. The info files will be stored in a compressed way but will nevertheless take up space both in the file and in RAM. It is therefore not recommended to use the bundle prefix when files are too large or too many.

The info may be referenced from the layout as normal info, via the info chart function or referenced as an internal file via the special syntax qmem://294fieldname / fieldvalue alternatively qmem:// fieldname / < index > where index is the internal index of a field value. The info prefix may be omitted when bundle is used.

The syntax is:

bundle [info] ( loadstatement | selectstatement)

Attached you will find an application which is using this.

Resolution:

To include an Image you need an Expression like this:

='qmem://FlagName/' & [Country]

and you must set up Image as Representation (Expression Tab in Properties)

Script:

Directory;
bundle Load Name As FlagName,
     Path As FlagPath
FROM
Pathes.xlsx
(ooxml, embedded labels, table is Flaglist);

LOAD * INLINE [
    Name, Country
    Thomas, Germany
    Hugo, Sweden
    Anton, USA
];

article How to use Info Load vs Bundle Load (QlikView) in Official Support Articles

How to use Info Load vs Bundle Load (QlikView)

Bundle

The syntax is:

Resolution:

Script: