Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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)