Info

The info prefix is used to link external information, such as a text file, a picture or a video to a field value.

Syntax:  

Info( loadstatement | selectstatement )

 

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, that is, 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.

Example:  

Info LOAD * inline[

LinkedField, ImageFileName

QlikView, QlikViewLogo.png

];

Result:

Only LinkedField will be visible as a field name.

If you add at text object to the sheet with representation set to Image, and enter the text =Info(LinkedField), the text object will show the image file name.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?