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: 
lampshadedreams
Contributor III
Contributor III

Set Analysis Trouble

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.

Labels (1)
1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

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

View solution in original post

3 Replies
dplr-rn
Partner - Master III
Partner - Master III

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

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

dplr-rn
Partner - Master III
Partner - Master III

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