topic Need to add arrows in pivot table in QlikView

Need to add arrows in pivot table

Wed, 25 Nov 2020 16:16:04 GMT

In pivot table, i have added 3 measures using the following calculations, I need to show up and down arrows for positive and negative values given by these measures.

The measures are as under:

1. Sum([Current Value])

2. Sum([Current Value]) - Sum([Prev Value])

3. (Sum([Current Value]) / Sum([Prev Value])) - 1

Re: Need to add arrows in pivot table

tamilarasu — Mon, 09 May 2016 10:36:11 GMT

You can check below link.

Qlik Design Blog : Replacing images with Geomet... | Qlik Community

Update: You can also include symbols in expression like below.

If(Sum(Sales)>0, '▲' & Sum(Sales) ,'▼ ' & Sum(Sales) )

Re: Need to add arrows in pivot table

avinashelite — Mon, 09 May 2016 10:39:11 GMT

check this too

Inserting image in pivot table | Qlik Community

Re: Need to add arrows in pivot table

MindaugasBacius — Mon, 09 May 2016 10:39:57 GMT

Check the link:

Replacing images with Geometric Shapes as visual cues

Re: Need to add arrows in pivot table

rrsrini2907 — Mon, 09 May 2016 10:54:12 GMT

Hi,

Check this http://stackoverflow.com/questions/2701192/character-for-up-down-triangle-arrow-to-display-in-html

basically you can add like below:

◄ = Chr(9668)
► = Chr(9658)
▼ = Chr(9660)
▲ = Chr(9650)

Regards,

Srini.

Re: Need to add arrows in pivot table

Peter_Cammaert — Mon, 09 May 2016 12:07:15 GMT

Although I would advise against showing arrows to simply indicate negative/positive values (first expression). That's what the minus sign is meant to do. A better idea would be to color the negative values red using the Text Color option.

Common practice in BI is to use arrows to indicate trends (improving, going up/down etc.) for which the second and third expressions are better candidates.

Best,

Peter