Can we show images (Not default trends) in text object based on if condition

[#1]

Hi All,

Can we show images (Not default trends) in text object based on if condition.

I need to show client specified images in text object based on condition.

Ex: if(Sales<=100000,Print Images 1,Print Image 2)

by using qlikview built in images we can do, but how can we work with other than qlikview built in images.

Please suggest me to get the above task.

Thanks,

UMAMAHESWARA REDDY

[#2]

Hi UmaMaheswar,

You can use two text objects, one on another, and use images separately and give conditions in "Layout" tab.

I think this may satisfies your requirement.

[tamilarasu · Accepted solution]

Hi Umamaheswara,

Have a look at the attachment.

[tamilarasu]

If you want to maintain the image names in external excel file (Instead of hard-coding the names into your application), you can follow the below link.

QlikView Technical Brief - Loading Images into QlikView.zip

[eromiyasimon]

You can display multiple images based on value condition using multiple ‘if’ condition as shown below,

Also attached the QVW for your further reference.

=if(sales='1000',

'C:\Documents and Settings\karthiklocal\Desktop\New Folder\1.jpg',

if(sales='2000',

'C:\Documents and Settings\karthiklocal\Desktop\New Folder\2.png',

if(sales='3000',

'C:\Documents and Settings\karthiklocal\Desktop\New Folder\3.png',

if(sales='4000',

'C:\Documents and Settings\karthiklocal\Desktop\New Folder\4.jpg',

if(sales='5000',

'C:\Documents and Settings\karthiklocal\Desktop\New Folder\5.jpg'

,'Select value to get started'

)))))

hope this helps