topic Re: using QV image as variable value in QlikView

using QV image as variable value

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

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

Re: using QV image as variable value

neelamsaroha157 — Tue, 04 Sep 2018 17:22:24 GMT

Can you try this -

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

Re: using QV image as variable value

csillamaglodi — Wed, 05 Sep 2018 08:24:47 GMT

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

Re: using QV image as variable value

neelamsaroha157 — Wed, 05 Sep 2018 15:50:45 GMT

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

Re: using QV image as variable value

neelamsaroha157 — Wed, 05 Sep 2018 15:53:46 GMT

The built-ins also works -

Re: using QV image as variable value

csillamaglodi — Wed, 10 Oct 2018 08:37:27 GMT

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