Trend cursors with numbers

Mon, 09 Dec 2013 06:50:57 GMT

How can I create a mini chart that will show a number and an UP/Down cursor highlighted with Green/Red by thresholds I define and based on calculation?

Thanks,

Boris

Re: Trend cursors with numbers

Anonymous — Mon, 09 Dec 2013 09:40:49 GMT

Hi Boris,

I dont think there is a way to show the images and the text in the same cell. However you can show them in spearate columns and change the UI a bit to make it look like one column.

You can use the Internal Images available in Qlikview app itself to achieve this.

You can put in your conditions and then use the below info to show up the arrows on the chart. (You will have to change the Representation from "Text" to "Image" for the arrows to appear on the chart.

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.

The above snippet was taken from the Qlikview help available in the Qlikview app itself.

Hope that helps.

Regards,
Aadil

topic Trend cursors with numbers in QlikView

Trend cursors with numbers

Re: Trend cursors with numbers

Internal Files

Arrow Images