topic Issue in displaying image in pivot table in QlikView

Issue in displaying image in pivot table

Wed, 06 Jan 2010 05:06:07 GMT

Hi All,
In "Growth in sales" pivot table, I want to display anyother images other than those two images which is already there for <0 and >0 values. Hope some one can helpme out.

I have attached the document. Please check it out!

Issue in displaying image in pivot table

Anonymous — Wed, 06 Jan 2010 05:21:56 GMT

Hi,

You have not attached the document

Issue in displaying image in pivot table

Wed, 06 Jan 2010 05:42:33 GMT

Sorry! I have attached it now please check it out! And provide some solution for me as soon as possible.

Issue in displaying image in pivot table

Mon, 11 Jan 2010 23:41:30 GMT

You can use any picture you want.
Place your images in a subfolder to your document and enter the relative path to the image enclosed in single quotes. ( 'images/myImage.jpg' )

regards
/Fredrik

Issue in displaying image in pivot table

Tue, 12 Jan 2010 05:38:00 GMT

Hi Fredrik!

Thanks for your reply! But that is not what i wanted for. I want to display the images according to the criteria in pivot table. Look into the attachment for your reference. Any doubts please get back to me!

Issue in displaying image in pivot table

Tue, 12 Jan 2010 11:19:02 GMT

You only need to find some nice images and link those instead of the arrow. I used two colored marbles from a different program.

You need to change the expression in Growth


if(Sum(SalValue) - before(Sum(SalValue)) < 0,'F:\Red.png','F:\Green.png')

Issue in displaying image in pivot table

Tue, 12 Jan 2010 11:41:32 GMT

Hi Mark!

Thanks for your reply. It works exactly same like mine only. So I didn't the solution yet. Because I want to display 3 different images according to the 3 different criteria.

1. if(Sum(SalValue) - before(Sum(SalValue)) < 0 --> Image 1

2. if(Sum(SalValue) - before(Sum(SalValue)) > 0 --> Image 2

3. if(Sum(SalValue) - before(Sum(SalValue)) = 0 --> Image 3

If any doubts please get back to me!

if(Sum(SalValue) - before(Sum(SalValue)) < 0,'F:\Prive\BRPG v1_4L\Objects\Generic Tokens, Large\Red.png','F:\Prive\BRPG v1_4L\Objects\Generic Tokens, Large\Green.png')

Issue in displaying image in pivot table

Tue, 12 Jan 2010 11:50:45 GMT

Small change in the expression (there are several possibilities to write the expression)


if(Sum(SalValue) - before(Sum(SalValue)) < 0,'F:\Red.png', if(Sum(SalValue) - before(Sum(SalValue)) > 0, 'F:\Green.png','F:\Blue.png'))

< 0 = Red

> 0 = Green

= 0 = Blue

Issue in displaying image in pivot table

Tue, 12 Jan 2010 12:07:52 GMT

It is working perfectly! Thanks a ton!