topic Increased / Decreased indicator in QlikView

Increased / Decreased indicator

Thu, 05 Nov 2009 13:20:40 GMT

i'd like to know if there is any way in QlikView to show an increased or decreased indication. For example, i'd like to have a green arrow pointing upwards next to a value if it has increased over the past one day. Or a red colored arrow pointing downwards next to a value, if it has decreased. Similar to a Share value representation.

Any ideas on how this can be done?

Increased / Decreased indicator

Thu, 05 Nov 2009 14:54:01 GMT

Hi,

see the attached example for your first steps.

Good luck!

Rainer

Increased / Decreased indicator

Thu, 05 Nov 2009 19:13:44 GMT

in a straight table, create an expression like this



if(Value>0,'qmem://<bundled>/BuiltIn/arrow_n_g.png','qmem://<bundled>/BuiltIn/arrow_s_r.png')

This can be built using the expression wizard (image tab) and then you have to make sure that you deem the column an Image in the display options.