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

1 Solution

Accepted Solutions
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]))

View solution in original post

17 Replies
shraddha_g
Partner - Master III
Partner - Master III

Try,

sum(

if(

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

)

)

Anonymous
Not applicable
Author

it says "error in expression"

Anonymous
Not applicable
Author

I have also tried this but still shows "error in expression"

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

shraddha_g
Partner - Master III
Partner - Master III

can you share sample app?

Anonymous
Not applicable
Author

Talk Hold = sum(([Aggr tTalkComplete])/1000)+(sum([Aggr tHeld])/1000)

beyond 10mins = if((sum([Aggr tTalkComplete])/1000)+(sum([Aggr tHeld])/1000)>600,1,0)

Capture.JPG

so the problem is this.. the sumbeyond10mins should show 4

Capture.JPG2.JPG

Thank you Shraddha!

shraddha_g
Partner - Master III
Partner - Master III

In 2nd Image showing Date & sumbeyond10mins what you have used?

shraddha_g
Partner - Master III
Partner - Master III

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

Should work in 2nd image

Anonymous
Not applicable
Author

i just copied the expression of beyond10mins because i also tried this (exactly what you are suggesting) but says

error.

Capture.JPG3.JPG

shraddha_g
Partner - Master III
Partner - Master III

Try using Variables for

sum([Aggr tTalkComplete])/1000

and sum([Aggr tHeld])/1000

and use those variables here