Skip to main content
Announcements
MAINTENANCE ALERT: Search experience upgrade - Feb 6: 4 - 8:30AM CET. Downtime expected. READ MORE

How to use Info Load vs Bundle Load (QlikView)

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Sonja_Bauernfeind
Digital Support
Digital Support

How to use Info Load vs Bundle Load (QlikView)

Last Update:

Jan 21, 2021 4:32:44 AM

Updated By:

Sonja_Bauernfeind

Created date:

Jul 12, 2012 5:11:43 AM

Attachments

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
];

 

Labels (1)
Contributors
Version history
Last update:
‎2021-01-21 04:32 AM
Updated by: