Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Test:
{">=180<240"}
Without comma and using double quota
worked a treat - many thanks!!