This content has been marked as final. Show 2 replies
I'm just new in Qlik and I'm trying to count the number that is greater than 600s when I add the two dimensions:
num(((sum([Aggr tTalkComplete]))/1000)+(((sum([Aggr tHeld]))/1000))
if the above total is greater than 600, then count as 1 if not 0
this is not working.
(((((sum([Aggr tTalkComplete])/sum([Aggr nHandle]))/1000) + (sum([Aggr tHeld])/sum([Aggr nHandle])/1000))] <= 600) ,1,null())
please help.. please please
thanks for those who will answer