2 Replies Latest reply: Sep 28, 2011 11:22 AM by Matt Facer RSS

    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