Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Tags (2)
1 Solution

Accepted Solutions
Employee
Employee

count if with multiple criteria

Test:
{">=180<240"}

Without comma and using double quota

2 Replies
Employee
Employee

count if with multiple criteria

Test:
{">=180<240"}

Without comma and using double quota

Not applicable

count if with multiple criteria

worked a treat - many thanks!!

Community Browser