topic Re: Display Image Condition in QlikView

Display Image Condition

theboss-123 — Wed, 20 Jan 2021 14:37:06 GMT

Hello ,

I have Some Images Rating Stars and table of value,

i need to set a condition to display Image by condition

from example for [Field]>=1 and [Field]<10 display Image 1

and [Field]>=11 and [Field]<20display Image 2 and so on

how can i put that in layout condition thanks in advancy.

Re: Display Image Condition

QFabian — Wed, 20 Jan 2021 16:44:29 GMT

Hi @theboss-123 , if you want to use images, this can be an example :

Expression : ='C:\Users\fquez\Documents\comm\' & F2 & '_stars.png', so i have 5 images, and according to the value, is going to show the stars, the expression have to be as image representation.

But you can do it with a linear gauge expression representation in a straight table too :

Please check the Qvw to see if it works for you

Re: Display Image Condition

theboss-123 — Wed, 20 Jan 2021 16:48:34 GMT

hi Qfabian,

me im looking for expression condition to display image between two value my approach is correct just i need how to write condition between two value

Re: Display Image Condition

QFabian — Wed, 20 Jan 2021 16:54:30 GMT

In that case, something like this? :

if(F2 < 3, 'C:\Users\fquez\Documents\comm\1_stars.png',
'C:\Users\fquez\Documents\comm\5_stars.png')

Re: Display Image Condition

theboss-123 — Wed, 20 Jan 2021 16:57:54 GMT

Thanks for you availibilty but if(F2 < 3, 'C:\Users\fquez\Documents\comm\1_stars.png',
'C:\Users\fquez\Documents\comm\5_stars.png')

i have 5 images however ur condition apply just to two images.

Re: Display Image Condition

theboss-123 — Wed, 20 Jan 2021 17:05:05 GMT

I Tried your condition but unfortanutally it doesn't work,

Re: Display Image Condition

theboss-123 — Wed, 20 Jan 2021 17:33:53 GMT

this condition is ok but that cannot affect the displaying of images.any suggestion ?

=if(QTY_0<=10,'C:\Users\secre\Desktop\TMP\Stars\1star.png',If(QTY_0<=20,'C:\Users\secre\Desktop\TMP\Stars\2star.png','C:\Users\secre\Desktop\TMP\Stars\5star.png'))

Re: Display Image Condition

theboss-123 — Wed, 20 Jan 2021 22:35:57 GMT

Hi the problem solved ,