topic Re: Error qmem use in QlikView

Error qmem use

MauriceLudo — Fri, 02 Dec 2016 09:39:08 GMT

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

Re: Error qmem use

avinashelite — Fri, 02 Dec 2016 09:43:49 GMT

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

Re: Error qmem use

MauriceLudo — Fri, 02 Dec 2016 09:49:34 GMT

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

Re: Error qmem use

MauriceLudo — Fri, 02 Dec 2016 09:54:25 GMT

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

Re: Error qmem use

avinashelite — Fri, 02 Dec 2016 10:07:11 GMT

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

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

Hope this helps you

Re: Error qmem use

MauriceLudo — Fri, 02 Dec 2016 10:21:48 GMT

Here is the example.

Thank you

Re: Error qmem use

avinashelite — Fri, 02 Dec 2016 10:36:08 GMT

Check the attachment for the soultion

Re: Error qmem use

MauriceLudo — Fri, 02 Dec 2016 10:45:10 GMT

Thank you very much

Re: Error qmem use

avinashelite — Fri, 02 Dec 2016 10:46:33 GMT

your always welcome