How to change an image on the basis of conditions

[#1]

Hi All,

I want to change an image( not predefind by qlikview) on the basis of some condition, when you click on the the item in the list box.

Plz reply ASAP.

Thanks,

Sandeep

[Annette_Steinrücken]

Hi,

you may have a look at the presidents application.

Here you can find a good example.
1) You have to load a list of keys and picturenames as an 'info load'

2) and in the list box where you will show the image, you write as an expression:

=

if(Count(distinct Name) > 1, '', Sequence & ' - ' & Name)

I hope this helps, Annette

[#3]

Thanku Annette,

my problem is , i have some Company code as 101,102....

every code represend a unique company name.

so i have to show the logo according to the company code

Thanks,

Sandeep

[Annette_Steinrücken · Accepted solution]

Hi Sandeep,

Here's the script syntax:

bundle info LOAD IName,

image

FROM

(ooxml, embedded labels, table is Sheet1);

Load * Inline [

code, name, IName

101, AAA, a

102, BBB, b];

The excel sheet contains:

IName	image
a	C:\Documents and Settings\ask\My Documents\QV reference group\QlikCom\arrow.gif
b	C:\Documents and Settings\ask\My Documents\QV reference group\QlikCom\ostampel.jpg

In the QlikView application you use a text box and use =info(IName) as the expression and set the Representation as 'Image'

Anyway, presidents is a good example for this too.

BR, Annette

[#5]

Thanku BR, Annette.

My problem is solved by using ur code 🙂