Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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)