topic Re: True or False if value exists in QlikView

True or False if value exists

Tue, 28 Oct 2014 08:50:23 GMT

Hey,

Iam importing a excel sheet. I make a gauge chart (showing green or red light) if the value is there.

As an example i got a field named Object.

I want the light to be red if the object field consists of value "SSSMMM" and green if the valie "SSSMMM" is not there.

Tried the expression if(Object='SSSMMM', 'True', 'False'")

Any ideas here?

Thanks

Gysbert_Wassenaar — Tue, 28 Oct 2014 08:55:53 GMT

Try if(Object='SSSMMM',1, 0)

amit_saini — Tue, 28 Oct 2014 09:03:34 GMT

Erik,

This should work:

If(Object='SSSMMM','Yes','No')

If not share your application.

Thanks,
AS