Mini chart arrows in expression columns

[aaronnayan]

Hi Guys

How do i include small arrows that go up and down next to my values in my expressions.

My dimensions are months so i want the arrow to be alongside the text and to show up or down to say if the value has gone better or worse since the following month

Similar to %variance

[Anil_Babu_Samineni]

We have options these all in single object. Check attachment

[aaronnayan]

could you help rectfy this statement Anil?

if([Acutal]- <100,'qmem://<bundled>/BuiltIn/arrow_s_r.png'), ([Acutal]- >1,'qmem://<bundled>/BuiltIn/arrow_n_g.png')

[Anil_Babu_Samineni · Accepted solution]

We have inbuilt images for Qlik. Just maximize the expression and bottom side we have bucket called Images. There You have to select as needed. It works like charm if you use below

if( ([Acutal]- ) <100,'qmem://<bundled>/BuiltIn/arrow_s_r.png'),

     If( ([Acutal]- ) >1,'qmem://<bundled>/BuiltIn/arrow_n_g.png'))

[aaronnayan]

That actually does not work i have tried using it

[Anil_Babu_Samineni]

Does Actual and B are two fields?

[aaronnayan]

no they are  expression column names

[Anil_Babu_Samineni]

Okay, Then i would suggest you to share MOC application to help. Try with whole expression and then check whether it is working or not