topic Display image according to the value! in QlikView

Display image according to the value!

Mon, 04 Jan 2010 19:47:07 GMT

Hi All,

I want to display the image according to the sales value. (i,e) If the sales value is in +ve when compared to the last month then there should be some image should be displayed, if the values is in -ve then there should be some image and if in the both the months there is no sale happened then there should be some image displayed.

Something is like this.

2006 2007 Variance Image
A1 B1 +ve Image1(This image i am able to display)
A2 B2 -ve Image2(This image i am able to display)
A3(0) B3(0) 0 Image3(This image i am not able to display)

I used below expression:

if(Sum(SalValue) - before(Sum(SalValue)) < 0,'qmem://<bundled>/BuiltIn/arrow_se_r.png','qmem://<bundled>/BuiltIn/arrow_ne_g.png')

Using the above expression i am able to do the first 2 rows but not the 3rd row.

Let me know what changes i need to do!

Display image according to the value!

Mon, 04 Jan 2010 19:54:10 GMT

if(Sum(SalValue) - before(Sum(SalValue)) < 0,'qmem://<bundled>/BuiltIn/arrow_se_r.png',if(Sum(SalValue) - before(Sum(SalValue)) =0,'qmem://<bundled>/BuiltIn/arrow_e.png',,'qmem://<bundled>/BuiltIn/arrow_ne_g.png')

Should do it...

Display image according to the value!

Tue, 05 Jan 2010 05:42:38 GMT

Sorry! It's not working! Any other solution please...

Display image according to the value!

Tue, 22 Feb 2011 19:19:28 GMT

try this:

if(Sum(SalValue) - before(Sum(SalValue)) = 0,'qmem://<bundled>/BuiltIn/arrow_e.png',

if(Sum(SalValue) - before(Sum(SalValue)) > 0,'qmem://<bundled>/BuiltIn/arrow_ne_g.png',

if(Sum(SalValue) - before(Sum(SalValue)) < 0,'qmem://<bundled>/BuiltIn/arrow_se_r.png', Null())))

regards