topic Mini chart arrows in expression columns in QlikView

Mini chart arrows in expression columns

aaronnayan — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Mini chart arrows in expression columns

Anil_Babu_Samineni — Mon, 19 Jun 2017 08:57:47 GMT

We have options these all in single object. Check attachment

Re: Mini chart arrows in expression columns

aaronnayan — Mon, 19 Jun 2017 09:03:52 GMT

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')

Re: Mini chart arrows in expression columns

Anil_Babu_Samineni — Mon, 19 Jun 2017 09:07:09 GMT

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'))

Re: Mini chart arrows in expression columns

aaronnayan — Mon, 19 Jun 2017 09:10:44 GMT

That actually does not work i have tried using it

Re: Mini chart arrows in expression columns

Anil_Babu_Samineni — Mon, 19 Jun 2017 09:12:41 GMT

Does Actual and B are two fields?

Re: Mini chart arrows in expression columns

aaronnayan — Mon, 19 Jun 2017 09:14:11 GMT

no they are expression column names

Re: Mini chart arrows in expression columns

Anil_Babu_Samineni — Mon, 19 Jun 2017 09:16:12 GMT

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