Count value if other value is less than

[Lucas3594]

Hey all,

As i'm new to Qlik Sense I have a (probably) pretty basic question.

For a call center I need to put together an expression based on 2 columns of data, column 1 is talktime (of the operator) and column 2 is the queuetime (time the customer was waiting on the phone).

I need to extract the number of times where the talktime is 0 (which means the operator lost the call/didn't take the call on time) and where queuetime is less than 30 seconds for example  (which means that the  customer hasn't waited 30 seconds).

What I have so far:

if(Queuetime'<=30',count(if(TalkTime=0,1)))

The second part of the expression seems to work when I compare data to my excel file, however I can't seem to incorporate the first part of the expression.

Thanks in advance!

[JuanGerardo · Accepted solution]

Hi @Lucas3594,  I think you better use set analysis to get this metric:

Count({<Queuetime = {"<30"}, talktime={0}>} talktime)

It will be more efficient and easier to maintain.

JG

[Lucas3594]

Thank you so much, worked like a charm! 🙂