Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Need to add arrows in pivot table

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

5 Replies

Re: Need to add arrows in pivot table

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

MindaugasBacius
Valued Contributor II

Re: Need to add arrows in pivot table

Highlighted
rrsrini2907
Contributor

Re: Need to add arrows in pivot table

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

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