Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
What is to be added here - is what I am failing. I added "=GetSelectedCount(vSelectedProvince) = 1" and it says calculation condition is not fulfilled.