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?
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).
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.
