using QV image as variable value

[csillamaglodi]

Hi,

I am using QV 12 and building a dashboard where I'd like to present the direction of change. I have the Spend value calculated for current and prior year and a variable [vChange] which calculates current-prior $. Now, I want to show in another text box the direction of the change, whether there is an increase or decrease in YTD spend. So, I assumed that with a simple IF condition I can do that, but no matter how QlikView inserts the selected picture, I do not see it in my textbox, only my formula is visible there, so something must be incorrect.

[vChange]= =if( [vCurrent vs Prior] >0,vUp,'^')

QV says the Expression is OK, but the arrow is not being shown.

Can you please help  to rewrite the formula or what else to do in order to make the picture visible?

many thanks,

Csilla

[neelamsaroha157 · Accepted solution]

Can you try this -

if([vCurrent vs Prior] >0, '▲',  '▼')

[csillamaglodi]

Hi Neelam,

thanks a lot, appreciate your help.

It does work, but wanted to use the colored, already built-in ones, just not sure how to properly include that into the script.

But until we figure it out, I will use your solution and define the right color for both direction signs.

cheers

[neelamsaroha157]

You can use the color as well with this as well.

[neelamsaroha157]

The built-ins also works  -

[csillamaglodi]

Thanks for both, Neelam! I will try these shortly.