Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How do you insert a $Info table in QlikView script?

Hi all,

I can see there is an option to insert some kind of Info table as the System Fields shows a $Info option.

Anybody know what an Info table is and how you insert one as a example?

An example of when you would use it would also be great!

1 Reply
MVP & Luminary
MVP & Luminary

Re: How do you insert a $Info table in QlikView script?

It's amazing how many people don't know that Qlikview Desktop has a Help file:

Info

If a piece of external information, such as a text file, a picture or a video is to be linked to a field value, this is done in a table that is loaded using an info prefix. (In some cases it will be preferable to store the information inside the .qvw file, by using the Bundle prefix.) The table must contain two columns only, the first one with the field values that will form the keys to the information, the second one containing the information elements, e.g. the file names of the pictures etcetera.

The same applies to, for example, a picture from a database management system. On a binary field, a blob, the info select statement makes an implicit bundle, i.e. the binary data will be fetched immediately and stored in the qvw. The binary data must be the second field in a select statement.

The syntax is:

info ( loadstatement | selectstatement )

Examples:

Info LOAD * FROM flagoecd.csv;

Info SQL SELECT * FROM infotable;

Info SQL SELECT Key, Picture FROM infotable;

You can find an example in this blog post: Loading Images into QlikView


talk is cheap, supply exceeds demand
Community Browser