Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

count if with multiple criteria

Hi. I've been googling and looking around here for some help with count if statements within Qlikview.

So far I've managed to use

count({< TalkTime = {'>=180,<240'} >}  distinct(callerID) )

However, the numbers just don't seem to be correct. I have in my database hundreds of call records and want to count those less than 3 minutes, 3-4 minutes etc. The one above should count just those calls which are 3-4 minutes in length.

Is this correct?

Many thanks

1 Solution

Accepted Solutions
GabrielAraya
Employee
Employee

Test:
{">=180<240"}

Without comma and using double quota

View solution in original post

2 Replies
GabrielAraya
Employee
Employee

Test:
{">=180<240"}

Without comma and using double quota

Not applicable
Author

worked a treat - many thanks!!