I am using a parameter that can have multiple values but when user selects above certain number of values I have to return some information on the sheet. Is there a possibility to check how many values user selected?
Please, I would appreciate any help.
Many thanks,
Konrad.
Hi @KonradAntczak
the multiselect values should have a delimiter. Maybe you can count the delimiter and you know if one or many elements are selected.
Can you check that?
BR
Thanks a lot, could you tell me how can I count it? From what I have tested the split function does not apply to parameters
Hello @KonradAntczak, you can create a calculated field that does a distinct_count on the dataset field that is being filtered by the parameter. Then as long as that field was used in a visual being filtered by the parameter, it would return the expected value. You could use it in an ifelse statement to display the information you want when the number exceeds the value you determined.
