Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Add Image if compare the condition

Hello,

I want to add image to QV model.

I want to view this image only if some field = x (for example: I want to see this image only if "Owner=Elad")

How I can do this?

Elad

2 Replies
Not applicable
Author

In the Layout tab you have conditional show where you can add the following code:


=if(Owner='Elad',1,0)




Whenever your expression in that box returns 1 it will show.

/Fredrik



Not applicable
Author

I'm assuming that you have some jpeg images available that you want to use, my example uses currency symbols and in a table will change the currency symbol according to values held in a field.

1. Load up your symbols/images from your external source, the following loads from an Excel sheet that has IName and Image as columns.

bundle info LOAD Iname

,Image

FROM

C:\QLIKVIEW\Image\CurrencySymbols.xlsx (ooxml, embedded labels, table is Sheet1);



2. For the whole process to work, I have formed a link (using IName) to my data table

3. In my table, add an expression for Image which is

=Info(Iname)


4. Make sure that this expression has a representation type of Image

Hope this helps, I have attached my sample QVW.