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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.