Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
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

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Not applicable

listbox as checkbox

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
Highlighted
Not applicable

listbox as checkbox

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

Highlighted

listbox as checkbox

Hi,

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

Regards.