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 not using 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 Reply
Anil_Babu_Samineni

Are you getting something when we use this

If(vTalkHold > 600, 1, 0)

OR

If($(vTalkHold) > 600, 1, 0)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)