EXPRESSION IMAGE

[#1]

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

[amit_saini]

Hi,

Check:

https://community.qlik.com/message/285163#285163

Thanks,

AS

[sunny_talwar]

Check this Blog out also: Loading Images into QlikView

Best,

Sunny

[#4]

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.