Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
csillamaglodi
New Contributor II

using QV image as variable value

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

1 Solution

Accepted Solutions
neelamsaroha157
Valued Contributor II

Re: using QV image as variable value

Can you try this -

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

5 Replies
neelamsaroha157
Valued Contributor II

Re: using QV image as variable value

Can you try this -

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

csillamaglodi
New Contributor II

Re: using QV image as variable value

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
Valued Contributor II

Re: using QV image as variable value

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

Capture12.PNGCapture11.PNG

Capture9.PNG

neelamsaroha157
Valued Contributor II

Re: using QV image as variable value

The built-ins also works  -

Capture9.PNG

csillamaglodi
New Contributor II

Re: using QV image as variable value

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