Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
AdrianS1
Contributor III
Contributor III

Counting the number of active filters on FiltersPane

Hi, How I can write a  measure which give me a count of active filters on filters pane in Qlik Sense. I have a filter pane which have 4 filters a,b,c,d. For example i pick a and b on filters pane and i want to have a number=2. If i pick a,b,c,d i want to have a number 4

Labels (5)
1 Reply
Mark_Little
Luminary
Luminary

Hi

You want to Look at the GetSelectedCount() function.

Should be something like

GetSelectedCount(a) +

GetSelectedCount(b)+

GetSelectedCount (c)+

GetSelectedCount (d)

If you just want to know how many filter have selections then

 

IF(GetSelectedCount(a)>0,1) +

IF(GetSelectedCount(b)>0,1) +

IF(GetSelectedCount (c)>0,1) +

IF(GetSelectedCount (d)>0,1)