QlikWorld 2020 Global Conference. Join us to discover how to get the most from your data. Act fast. Register now and save.

Internal files

File References in the QlikView Layout

There are a number of places in the QlikView layout where external files can be referenced as info, as background images etc. External files are referenced by a local path or URL.

Internal Files in QlikView Documents

In certain cases it may be preferable to include the files in the QlikView document.

The info prefix to Load and Select statements in the script can be preceded (or replaced) by the bundle prefix. The external files will then be read and embedded in the QlikView document. The external files will no longer be necessary for referencing the file contents, thereby making the QlikView document portable.

Show info and the info function will automatically use the embedded files when available. The syntax for explicit reference of embedded files is:

qmem://fieldname/fieldvalue |

qmem://fieldname<index>

where index is the internal index of a value within a field.

Examples:  

'qmem://Country/Austria'

'qmem://MyField/34'

Internal Files in the QlikView Program File

A small set of standard image files are embedded in the QlikView program itself and may be used in any document without any special preparations.

A set of image files and sound files are already embedded in the QlikView program file. These may be referenced directly from the layout, without the need for any special preparations. The syntax for reference is:

qmem://<builtin>/filename

where filename is one of the filenames listed below (including extension).

Examples:  

'qmem://<builtin>/Arrow_N_G.png'

='qmem://<builtin>/Smiley'&if(sum(Result)<0,1,3)&'_Y.png'

Arrow Images

The arrows set permits you to display arrows in eight directions and four colors. Filenames are coded as follows: The word Arrow followed by a map direction ( _N, _NE, _E, _SE, _S, _SW, _W or _NW ). This may be followed by _G for green, _R for red and _Y for yellow. If no color is stated in the filename, a gray arrow is referenced.

Other Images

A number of other images are also included in the set. These are usually available in several colors. Below is a list of the available images.

Check.png

Check_G.png

Cross.png

Cross_R.png

Minus.png

Minus_R.png

Plus.png

Plus_G.png

Smiley1.png

Smiley1_G.png

Smiley1_Y.png

Smiley2.png

Smiley2_B.png

Smiley2_Y.png

Smiley3.png

Smiley3_R.png

Smiley3_Y.png

Thumb1.png

Thumb2.png

Question.png

Question_G.png

Question_R.png

Question_Y.png

Exclamation.png

Exclamation_G.png

Exclamation_R.png

Exclamation_Y.png

 

Sounds

A number of sound files (.wav) are also included as bundled resources within QlikView, accesses via the following paths:

qmem://<bundled>/sounds/qv_bttn.wav

qmem://<bundled>/sounds/qv_can.wav

qmem://<bundled>/sounds/qv_clear.wav

qmem://<bundled>/sounds/qv_load.wav

qmem://<bundled>/sounds/qv_lock.wav

qmem://<bundled>/sounds/qv_menu.wav

qmem://<bundled>/sounds/qv_ok.wav

qmem://<bundled>/sounds/qv_redo.wav

qmem://<bundled>/sounds/qv_reex.wav

qmem://<bundled>/sounds/qv_save.wav

qmem://<bundled>/sounds/qv_scrpt.wav

qmem://<bundled>/sounds/qv_ulock.wav

qmem://<bundled>/sounds/qv_undo.wav

Note: This list may change in future versions of QlikView.

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?