Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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.