Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
varunreddy
Creator III
Creator III

Is there a way to restrict get selected count to particular values?

Hi,

Is there a way to restrict get selected count to particular values?

I am looking to restrict get selected count for:

BCBS and BCBS- Accuracy.

Thank in advance!

Cheers,

Varun

5 Replies
sunny_talwar

May be use Count() function in that case:

If(GetSelectedCount(FieldName) > 0, Count(DISTINCT {<FieldName = {'BCBS', ;BCBS - Accuracy'}>} FieldName))

varunreddy
Creator III
Creator III
Author

If I select a button, it should select BCBS and BCBS-Accuracy across dashboard. If I select button for secong time, then the selections should be cleared.

This is what I am trying to do!

varunreddy
Creator III
Creator III
Author

If I select a button, it should select BCBS and BCBS-Accuracy across dashboard. If I select button for secong time, then the selections should be cleared.

This is what I am trying to do!

Should I use above mentioned expression in Layout?

sunny_talwar

Try this:

=If(GetSelectedCount(FieldName) = 0, '(BCBS|BCBS-Accuracy)')

Attaching a sample with this post for you to review.

Best,

Sunny

MarcoWedel

Hi,

another solution could be (using sunindia example):

QlikCommunity_Thread_188249_Pic1.JPG

QlikCommunity_Thread_188249_Pic2.JPG

QlikCommunity_Thread_188249_Pic3.JPG

hope this helps

regards

Marco