Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

listbox as checkbox

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

1 Solution

Accepted Solutions
Not applicable
Author

Hi Sravan,

I recommend making a new field in your script.


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


View solution in original post

2 Replies
Not applicable
Author

Hi Sravan,

I recommend making a new field in your script.


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


Miguel_Angel_Baeyens

Hi,

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

Regards.