Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
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
dilipranjith
Partner
Partner

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

View solution in original post

3 Replies
dilipranjith
Partner
Partner

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? 

dilipranjith
Partner
Partner

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

View solution in original post