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?