Red or green arrow image based on values

[rsdhavle]

Can we get additional column which contains red or green arrow based on the values?

[#2]

Yes, if(Value > dep_Value,red(),green())

Check out the app

[Gysbert_Wassenaar]

Yes. See this blog post: Replacing images with Geometric Shapes as visual cues

[suresh_rawat]

Hi Rohan,

Yes you can get the additional coloumn which contains red or green arrow  based on the values.

- > Use a straight or Pivot table

-> write a expression based on your condition

     then use in if else condition in your expresion

'qmem://<bundled>/BuiltIn/arrow_n_g.png' - (Green Arrow)

'qmem://<bundled>/BuiltIn/arrow_n_r.png' - (Red Arrow)

     Dont write Green and Red arrow this is only to make understand.

-> In Properties - > Expression - > Display Option - > Representation -> Image(By default it is text change to image).

Kindly refer the image as attached.

Hope this will work out for you.

Regards

Suresh Rawat

[rsdhavle]

Thanks all for the response..

@ Suresh,

Can i combine the arrow with expression so that lets say i get value as 72.72(Upper Arrow) in a single column?

How can we use IF expression for that? or any other function?

[#6]

hi, try something like this

if(sum(TargetValue)>72.22,'qmem://<bundled>/BuiltIn/arrow_s_r.png',

if(sum(TargetValue)<72.22,'qmem://<bundled>/BuiltIn/arrow_n_g.png'))

[suresh_rawat]

Hi Rohan,

As of I know, I don't think it so in QlikView we can combine value and arrow in a single column.

For the use of if condition

In the above post Dushan mention how to use if condition.

Regards

Suresh Rawat

[rsdhavle]

This will not give value of expression..it will only give arrow

[#9]

hi Rohan,

just try with '& ' operator to concatenate your two fields . I think it may help you with the problem

'value' & ' arrow condition '

best rgrds

Dushan

[suresh_rawat]

Hi,

Dushan - Actually for getting arrows we have to make representation as image in Expression.

              For Data - representation should be text.

That is why we can't do this in QlikView.

Regards

Suresh Rawat