topic Re: Chain image file to text object expression in QlikView

Chain image file to text object expression

Tue, 10 Dec 2013 07:27:12 GMT

Hi, I need to show a calculated number and then by thresholds to make it freen or red with an arrow (up/down)

I have 2 arrow PNG's and I want to add them into the expression I write in the text box.

how can I do it? what is the syntax?

regards,

Boris

Re: Chain image file to text object expression

Anonymous — Tue, 10 Dec 2013 07:30:41 GMT

check this about using images.

Internal Files

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.

also this one..

Bundle

The Bundleprefix is used to include external files, such as image or sound files, or objects connected to a field value, to be stored in the qvw file.

If a piece of external information, such as an image or a sound file is to be connected to a field value, this is done in a table that is loaded with the Info prefix. In order to maintain portability, it is possible to include the external files into the .qvw file itself. To this end use the Bundle prefix. The bundled info files are compressed in the process, but will nevertheless take up additional space both in the file and in RAM. Therefore consider both the size and the number of bundled files before going for this solution.

The info may be referenced from the layout as normal info, via the chart info function or as an internal file via the special syntax qmem:// fieldname / 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.

Bundle[Info] ( loadstatement | selectstatement)

Examples:

Bundle Info Load * Fom flagoecd.csv;

Bundle SQL Select * From infotable;

Re: Chain image file to text object expression

Tue, 10 Dec 2013 07:43:37 GMT

Is there a possibility for and example QVW?

I didn't quite understand the technique in case of 2 small PNG's I want to use.

Re: Re: Chain image file to text object expression

Anonymous — Tue, 10 Dec 2013 07:57:13 GMT

check attached.

Re: Chain image file to text object expression

Tue, 10 Dec 2013 15:25:42 GMT

Tried to do it as Qlikview suggest.

in the expression built I chose an arrow, and it pasted me the script automatically.

but it doesn't show the arrow, it shows the script itself.

any ideas?

Thanks

Re: Chain image file to text object expression

Tue, 10 Dec 2013 15:29:26 GMT

I tried to add a string before the INFO(KEY) and the image disappeared and it left the string with a path to a file.

Re: Chain image file to text object expression

DavidFoster1 — Tue, 10 Dec 2013 16:41:50 GMT

A better option is to use the extended ASCII characters.

There is a good blog on this somewhere, but I cant find my link to it.

If you use the windows character map you can find the following shapes: ▲▼

You can easily include these in a number format: (▲ #,##0; ▼ #,##0) and then use colouring expressions to set green for positive and red for negative.

Re: Chain image file to text object expression

stabben23 — Tue, 10 Dec 2013 17:53:32 GMT

//Staffan