Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am transiting from Qlikview to Qlik Sense and I find that if I construct a filter pane using an expression, I can no longer use the function "getselectedcount" to count the number of items selected. For example in my QS file, I define a field called "Year". Then in filter "B) Year (expression)", I defined an if expression to exclude the value "NA". Then I cannot count its selected value. Is there any way to get the selected count of filters with expression?
In addition, selecting a value in filter B will associate the selection in filter C but not in A. This is not the case in Qlikview and I find this behaviour rather odd. Is that any way to link all these filters together?
Thanks.
Yes, using aggr() is the solution I believe. Like: =Aggr(if(Year<>'NA', Year), Year) , or as you wrote.
Not sure if this is the right way to solve it, but I find that when I change the filter to the following expression, all filters are associated again and the getselectedcount() works too.
=Aggr(Only({<Year= {"*"}-{"NA"}>}Year), Year)
Any comment or further suggestion is welcome. Thanks.
Yes, using aggr() is the solution I believe. Like: =Aggr(if(Year<>'NA', Year), Year) , or as you wrote.
Great and I don't know aggr() can work with if() in this way. Thanks!