topic Zero values and Qmemm function in QlikView

Zero values and Qmemm function

Fri, 16 Oct 2009 16:46:05 GMT

Hi,

I am working with a dashboard in which a column called "Value" and a column "Target" is included. Made a expression in which i want to show an image if the value of the colummn "Value" is > than " target" -->

if (ActualValue>= TargetValue and TargetValue >'0','qmem://<bundled>/BuiltIn/check_g.png','qmem://<bundled>/BuiltIn/exclamation_r.png')

the problem is that if the columm "Target" has blank values, this expression still shows an image.

What i want is if the Targetvalue IS BLANK (OR ZERO) then no image has to be displayed....

how can i do this

thnx

Maarten

Zero values and Qmemm function

Fri, 16 Oct 2009 17:54:38 GMT

Hi Maarten,

You could try :

=if ("TargetValue"='','')

Thanks

Zero values and Qmemm function

Fri, 16 Oct 2009 18:12:25 GMT

Hi Xena

thnxs for the reply. The expression now looks like this:

if (TargetValue= ' ' and ActualValue>= TargetValue,'qmem://<bundled>/BuiltIn/check_g.png','qmem://<bundled>/BuiltIn/exclamation_r.png')

double quotes or not, it doesn t work.....

Any other ideas??

Zero values and Qmemm function

Fri, 16 Oct 2009 18:20:15 GMT

Hi,

please download a small QV example we can work with.

Thank you!

Rainer

Zero values and Qmemm function

Fri, 16 Oct 2009 18:26:28 GMT

Hi Rainer,

see attachment

thnx in advance

Maarten

Zero values and Qmemm function

Fri, 16 Oct 2009 20:36:48 GMT

HI Maarten,

I'm trying to attach the solution to this, but it's not allowing me.

I'll carry on trying.

Zero values and Qmemm function

Fri, 16 Oct 2009 20:43:00 GMT

Hi Maarten,

I have attached the solution for the .qvw.

I hope this helps.

Thanks

Zero values and Qmemm function

Fri, 16 Oct 2009 20:54:12 GMT

Hi Xena,

Great work!!!!

Thnx a lot

Maarten

Zero values and Qmemm function

Fri, 16 Oct 2009 21:09:24 GMT

Anytime