Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

set analysis without variable panel

Hi Everyone,

I really need your expertise.

I'm thinking to create a variable for Talk + Hold.

vTalkHold = num(((sum([Aggr tTalkComplete]))/1000)+(((sum([Aggr tHeld]))/1000)),vFormatSeconds2)

then I will do the below expression in sheets. sum(if([vTalkHold]>600,1,0))

But I do not have a variable panel access so I have to directly have this measure in master Item.

Please advise

17 Replies
shraddha_g
Partner - Master III
Partner - Master III

try:

Sum(

if(

((sum([Aggr tTalkComplete])/1000)+ (sum([Aggr tHeld])/1000) ) >600, 1, 0 ) )

Anonymous
Not applicable
Author

that's my problem. I do not have access to variable panel

Anonymous
Not applicable
Author

still error

shraddha_g
Partner - Master III
Partner - Master III

if possible share sample data in excel

Anonymous
Not applicable
Author

sorry.. how to attach excel file here?

but here's the simple data sample that you may input to excel.

the Aggr THeld and Aggr TTalkComplete are in millisecond format. that is why I am dividing them to 1000.

After dividing them, I have to add Aggr tHeld + Aggr TTalkComplete. if the total is more than 600sec then count as 1. so in the example i should have 2 data that is greater than 600sec

simpledata.JPG

this should be the result

resultshouldbe.JPG

Super Thanks!!!

shraddha_g
Partner - Master III
Partner - Master III

shraddha_g
Partner - Master III
Partner - Master III

See Attached app.

Created same expression in Load script.

shraddha_g
Partner - Master III
Partner - Master III

Also you can use this

sum(aggr(if(((sum([Aggr tHeld])/1000)+(sum([Aggr tTalkComplete])/1000))>600,1,0),Date,[Aggr tHeld],[Aggr tTalkComplete]))