Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

eustisab
New Contributor III

countif sum is <

I'm  counting those ID Conversations that were answered within 30seconds.

count id conversations if [tAnswered]<=30 and [nAnswered] =1

I've tried this expression, but there are 2 conversations that have incorrect results. (see attached)

Count( Distinct {<[Aggr tAnswered] ={"=sum([Aggr tAnswered])/1000<=30.00"},[Aggr nAnswered] ={1}>} [ID: Conversation])

2 Replies
hhajjali
New Contributor III

Re: countif sum is <

Hello,

Don't aggr in your set analysis, try this.

Count (Distinct {<[tAnsweres]=<{30}, [nAnswered] ={1}>} [ID: Conversation])

Regards

MVP
MVP

Re: countif sum is <

Acually the inequality should look like this:

=Count ({<tAnsweres={"<=30"}, nAnswered ={1}>} DISTINCT [ID: Conversation])