topic Add Image if compare the condition in QlikView

Add Image if compare the condition

Mon, 26 Oct 2009 17:20:33 GMT

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

Add Image if compare the condition

Mon, 26 Oct 2009 18:44:31 GMT

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

Add Image if compare the condition

Mon, 26 Oct 2009 18:52:23 GMT

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.