Comparing Present and Previous quarter images

Thu, 18 Jun 2015 10:48:52 GMT

Hi All,

I have field with metric

1=yellow

2=red

3=green

the Expression is

=if(Field='Green','3',

if(Field='Red','1',

if(Field='Yellow','2')))

TEXT Color

=if(Field='3','qmem://<bundled>/BuiltIn/led_g.png',

if(Field='1','qmem://<bundled>/BuiltIn/led_r.png',

if(Field='2','qmem://<bundled>/BuiltIn/led_y.png')))

Result is

I want to Compare with Current data with previous data with colours

if Previous quarter is green and present quarter result is Red then should show (custom Image)..

topic Comparing Present and Previous quarter images in QlikView