topic Showing image in column in QlikView

Showing image in column

Fri, 20 Jul 2012 12:37:24 GMT

How to show the image along with data in the same column of pivot table like ([image] [data]).

Re: Showing image in column

advait_thakur — Fri, 20 Jul 2012 12:48:44 GMT

Hi Ram,

In Qlikview, you cannot display Image and Data together in same Column.

I would like to suggest you to create two columns and keep data in one and image in another.

keep both the columns very close to each other.

See the sample file. I hope this will help you out.

Thanks,

Advait

Re: Showing image in column

cesaraccardi — Fri, 20 Jul 2012 13:02:06 GMT

In addition you can uncheck the "Vertical Expression Cell Borders" at the Presentation tab of your table... This will hide the lines between expressions.

Regards,

Cesar

Re: Showing image in column

Thu, 02 Aug 2012 08:28:04 GMT

Hi Advait,

Thanks for your reply.

But could you please elaborate more on how to relate the image with data present in other column. The image which you have attached is perfectly fine but how qlikview will know when to show Green upper arrow and red down arrow.

Re: Showing image in column

advait_thakur — Thu, 02 Aug 2012 09:05:44 GMT

Hello Ramkumar,

You can achieve this by going it into Expressions and in that particular expressions > click on + sign

and set Background color conditionally. (Chart Properties> Expression Tab)

It will automatically turns up according to your condition.

Also please look in Visual Cues, it might suffice your requirement.

Thanks,

Advait

Re: Showing image in column

Thu, 02 Aug 2012 09:50:15 GMT

Yes Advait, I have used the Visual Cues, with it one can change the color of text and some other formatting but cant show the image with data.

If you have any example ready with you, please do share.

Thanks.

Re: Showing image in column

Anonymous — Thu, 02 Aug 2012 12:58:28 GMT

hi ram , write the expression

like if ( sum(sales) >0 , image1, image2) (for image 1 or image 2 the url or path of the image should be given and also u can use qlikveiw default images )

and coming to the setting for image -> in the expression tab - represention - select the image

Re: Showing image in column

pkkushwaha — Fri, 05 Oct 2012 18:37:48 GMT

Hi All,

I am also seeking solution for this issue.

i want to display image and value together in qlikview cell.

please help and provide sample file.

Thanks in advance.

Pradeep

Re: Showing image in column

amars — Thu, 29 Nov 2012 01:26:00 GMT

Hi,

Please look at the attached file from the sample examples in Qlikview 10.

Refer the last tab Photo

Thanks