Zero values and Qmemm function

[#1]

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

[#2]

Hi Maarten,

You could try :

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

Thanks

[#3]

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??

[#4]

Hi,

please download a small QV example we can work with.

Thank you!

Rainer

[#5]

Hi Rainer,

see attachment

thnx in advance

Maarten

[#6]

HI Maarten,

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

I'll carry on trying.

[#7]

Hi Maarten,

I have attached the solution for the .qvw.

I hope this helps.

Thanks

[#8]

Hi Xena,

Great work!!!!

Thnx a lot

Maarten

[#9]

Anytime