Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
richard_chilvers
Specialist
Specialist

Check box to exclude value

In my table every record has a value in REC_TYPE of A, B, C, D.

In my dashboard, I want to always show records with values in REC_TYPE of A and B, and also default to include values of C and D.

But I want 2 check boxes:

Click Here to EXCLUDE REC_TYPE of C   [  ]

Click Here to EXCLUDE REC_TYPE of D   [  ]

Please advise a neat way to do this, or point me to the correct place on this forum.

Thanks

11 Replies
richard_chilvers
Specialist
Specialist
Author

I'm always conscious of supporting apps and deciding whether a development investment is worth the value it gives the end user. For my organisation it would be difficult for us to support/justify a complex formula such as this:

 

='=Sum({1<Type -= {$(=GetFieldSelections(RecType, chr(44)))} >} 1)'

I'm sure many developers for other organisations do this and more complicated apps.

But thanks for your help.

 

vikasmahajan

cool

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.