How Can I added upper and lower arrow indicators in Qlik Snese

[hammermill21]

Hello.

I have a pivot chart showing some scores and I have a trend column that I want to add arrow indicators. So like I change the colors for the different scores using this expression:

If(

Alt(Sum(Score)/Count({<Score={">0"}>}[Record ID])/3,0)>0.95,Green(),

If(Alt(Sum(Score)/Count({<Score={">0"}>}[Record ID])/3,0)>0.8,Yellow(),

If(Alt(Sum(Score)/Count({<Score={">0"}>}[Record ID])/3,0)>0,Red(),

DarkGray())))

So I was wondering if there was something like that I can do to add indicators to one of the columns?

Thanks!

Lizzy

[ogautier62 · Accepted solution]

Hi

look at this :

Re: How can put upper and lower arrow indicators in qlik sense?

regards

[hammermill21]

Hi,

Thank you! I got it working, but how can I also change the colors of the arrows?

So now I'm using this:

If(

Alt(Sum(Score)/Count({<Score={">0"}>}[Record ID])/3,0)>0.95,chr(9650),

If(Alt(Sum(Score)/Count({<Score={">0"}>}[Record ID])/3,0)>0.8,chr(8594),

If(Alt(Sum(Score)/Count({<Score={">0"}>}[Record ID])/3,0)>0,chr(9660),

DarkGray())))

[hammermill21]

Never mind, I got the colors working too. THANK YOU!

[Aswathy]

1. Add a new measure to the Pivot Chart for Trend indicators

2. Try expression like  If(Alt(Sum(Score)/Count({<Score={">0"}>}[Record ID])/3,0)>0.8,Chr(9650),Chr(9660))

3.In Text Color expression try

If(

Alt(Sum(Score)/Count({<Score={">0"}>}[Record ID])/3,0)>0.95,Green(),

If(Alt(Sum(Score)/Count({<Score={">0"}>}[Record ID])/3,0)>0.8,Yellow(),

If(Alt(Sum(Score)/Count({<Score={">0"}>}[Record ID])/3,0)>0,Red(),

DarkGray())))

Hope this Helps!