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: 
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