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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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!!