Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

EXPRESSION IMAGE

Is it possible to build an image into this expression to show red dots for areas that achieved a certain target of <=50% and a green dot for those that achieved say 80%

sum({<GA_ActualTarget={'Actual'}>}GA_No)/sum({<GA_ActualTarget={'Target'}>}GA_No)

Thanx

3 Replies
amit_saini
Master III
Master III

sunny_talwar

Check this Blog out also: Loading Images into QlikView

Best,

Sunny

Not applicable
Author

Hi ,

Try the following:

In the expression tab add this expression

if(sum({<GA_ActualTarget={'Actual'}>}GA_No)/sum({<GA_ActualTarget={'Target'}>}GA_No)<=0.5,'qmem://<bundled>/BuiltIn/led_r.png',if(sum({<GA_ActualTarget={'Actual'}>}GA_No)/sum({<GA_ActualTarget={'Target'}>}GA_No)>=0.8,'qmem://<bundled>/BuiltIn/led_g.png'))

and in the Expression Tab for Display Options ,select Image.