Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to use count with multiple criteria

I am trying to perform a ratio calculation that requires multiple criteria.  I am trying to get the percentage of orders that meet 2 criteria (visit column has a "1" AND Revisit column has "0").  I used a comma to separate the criteria at first but it doesn't seem to give the correct answer.  Is it correct that a comma would separate multiple criteria? Any ideas on what I may be doing wrong?

Thanks!

1 Solution

Accepted Solutions
sunny_talwar

Not sure what you have already tried, but may be this:

Count(DISTINCT {<Visit = {1}, Revisit = {0}>} Orders)

View solution in original post

2 Replies
igdrazil
Creator III
Creator III

Hi Sam,

It would look somewhat like this:

sum( {$<Visit = {'1'}, Revisit = {'0'}>} counter).

Hope this helps, good luck!

Regards

Chris

sunny_talwar

Not sure what you have already tried, but may be this:

Count(DISTINCT {<Visit = {1}, Revisit = {0}>} Orders)