Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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
Highlighted
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

Highlighted

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

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

View solution in original post