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: 
ss09
Contributor III
Contributor III

GetSelectedCount Not Working as intended

I have a filter which has the following logic: =Pick(Match($(vLanguage),1,2),province,province_french) and it works and gives me a Multi-select filter.

Now the objective is to allow the user to only select one field where the viz is displayed.

My Solution: =GetSelectedCount(Pick(Match($(vLanguage),1,2),province,province_french))=1 However, it always gives me 0, even when I select one province.

Labels (3)
2 Replies
Chanty4u
MVP
MVP

Hi

create a variable

vSelectedProvince:
=Pick(GetSelectedCount(province), province, province_french)

in filter use below exp

=Pick(Match($(vLanguage), 1, 2), province, province_french)

use GetSelectedCount on the variable

=GetSelectedCount(vSelectedProvince) = 1

ss09
Contributor III
Contributor III
Author

ss09_0-1697032353333.png

What is to be added here - is what I am failing. I added "=GetSelectedCount(vSelectedProvince) = 1" and it says calculation condition is not fulfilled.