topic EXPRESSION IMAGE in QlikView

EXPRESSION IMAGE

Thu, 28 May 2015 10:12:48 GMT

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

Re: EXPRESSION IMAGE

amit_saini — Thu, 28 May 2015 10:15:41 GMT

Hi,

Check:

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

Thanks,

Re: EXPRESSION IMAGE

sunny_talwar — Thu, 28 May 2015 10:18:10 GMT

Check this Blog out also: Loading Images into QlikView

Best,

Sunny

Re: EXPRESSION IMAGE

Mon, 01 Jun 2015 09:26:54 GMT

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.