Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MauriceLudo
Creator II
Creator II

Error qmem use

Hi,

I have not managed to run this script, could you help me find the error. Thank you for your help

=if(([Taux CPS ] >= 80),'qmem://<bundled>/BuiltIn/smiley1_g.png',

         if(([Taux  CPS ] >= 60) and ([Taux CPS] <=79),'qmem://<bundled>/BuiltIn/smiley2_y.png',

              'qmem://<bundled>/BuiltIn/smiley3_r.png')

)

Best regards,

Maurice

1 Solution

Accepted Solutions
avinashelite

Check the attachment for the soultion

View solution in original post

8 Replies
avinashelite

Syntax looks fine , whats the error your getting have you loaded the images in to QV and made the expression/dimension as the image ?

MauriceLudo
Creator II
Creator II
Author

I use a text box to display the rate, the color does not change, here is a screenshot

MauriceLudo
Creator II
Creator II
Author

I use a text box to display the rate, the color does not change, here is a screenshot

avinashelite

Your trying to display the images or the color background in text box? I could not see any attachment

[Taux CPS ] has all the values combination ? i.e. between 60 to 79, >80 etc if that is the case then we won't be able to display all the value in a text box select a particular value then you will see

or

add a straight table and add this as the expression and make the expression representation as image and try again



Hope this helps you

MauriceLudo
Creator II
Creator II
Author

Here is the example.

Thank you

avinashelite

Check the attachment for the soultion

MauriceLudo
Creator II
Creator II
Author

Thank you very much

avinashelite

your always welcome