topic Re: Set Analysis Trouble in QlikView

Set Analysis Trouble

lampshadedreams — Sat, 16 Nov 2024 03:21:48 GMT

Hi I am having a lot of trouble converting the following expression to set analysis:

=COUNT(if(Accuracy<=1.15 and Accuracy >=0.8,UserId)/COUNT(UserId)

The reason I need to convert it to set analysis is because I have to prevent the Month filter from affecting the expression. I know I would have to do use the construct {<Month=>} but I am not sure how this would fit into above.

Re: Set Analysis Trouble

dplr-rn — Fri, 07 Jun 2019 19:22:25 GMT

try changing it like below
COUNT({<Accuracy= {"<=1.15 >=0.8"}>}UserId)

Re: Set Analysis Trouble

lampshadedreams — Fri, 07 Jun 2019 19:31:58 GMT

yes but how do I add the construct {<Month=>} to prevent the Month filter from affecting the chart?

Re: Set Analysis Trouble

dplr-rn — Fri, 07 Jun 2019 19:33:20 GMT

COUNT({<Month=,Accuracy= {"<=1.15 >=0.8"}>}UserId)