Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)