Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to show the image along with data in the same column of pivot table like ([image] [data]).
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
Hi
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
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.
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
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.
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
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
Hi,
Please look at the attached file from the sample examples in Qlikview 10.
Refer the last tab Photo
Thanks