Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
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
Highlighted
Specialist II
Specialist II

Can you try this -

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

View solution in original post

5 Replies
Highlighted
Specialist II
Specialist II

Can you try this -

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

View solution in original post

Highlighted
Contributor II
Contributor II

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

Highlighted
Specialist II
Specialist II

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

Capture12.PNGCapture11.PNG

Capture9.PNG

Highlighted
Specialist II
Specialist II

The built-ins also works  -

Capture9.PNG

Highlighted
Contributor II
Contributor II

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