listbox as checkbox

Wed, 02 Mar 2011 16:59:31 GMT

Hi guys,

I created a checkbox from a listbox and everything works for this expression.


= if(match([MaterialTaste],'WATER','Water'),'WATER','ALL EXCEPT WATER')

This works and I get the display as follows:

Fig1 is when nothing is selected and is correct.

Fig2 is when Water Checkbox is selected and other selections(calendar options + other selections) are made. It works and is correct

Fig3 is when ALL EXCEPT WATER Checkbox is selected and other selections(calendar options + other selections) are made. I does not have a Tickmark.

How to get the tickmark also for ALL EXCEPT WATER checkbox? Any ideas.

Customers want it otherwise they are getting confused without tickmark.

Thanks and Regards

Sravan

listbox as checkbox

Wed, 02 Mar 2011 17:06:44 GMT

Hi Sravan,

I recommend making a new field in your script.


if(match([MaterialTaste],'WATER','Water'),'WATER','ALL EXCEPT WATER') as NewMaterialTaste

listbox as checkbox

Miguel_Angel_Baeyens — Wed, 02 Mar 2011 17:19:30 GMT

Hi,

You might use MixMatch() instead of Match(), since is case insensitive.

Regards.

topic listbox as checkbox in QlikView

listbox as checkbox

listbox as checkbox

listbox as checkbox