Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Multiple Grouping with conditions

Hi all,

Who can help?

Conditions:
1. Group1 (CallId): make a group segmented by CallId (in this example: 115, 117)
2. Group2 (Team):  make a group segmented by Team (in this example: B, K , A)
3. Condition grouping Group2 (Team): Find the team with the highest EventID (result Team 'A')
4. Condition within Group2: Find the highest EventID with EventType 'TALKING' and take its EventDuration time
5. Result schuld be: Team and its Talkingduration (EventDuration)
     

TeamTalkingduration
A1:52

 

the data is attached as well as Excel:

CallIdEventIdEventTypeTeamEventDuration
1151AUTO_ATTENDANTB00:00:04
1152RINGINGB00:00:05
1153TALKINGB00:02:37
1171AUTO_ATTENDANTB00:00:04
1172RINGINGB00:00:05
1173TALKINGB00:02:37
1174TRANSFER_HOLDB00:00:24
1175DIALING 00:00:00
1176QUEUEK00:00:00
117728K00:00:00
1178RINGINGA00:00:09
1179TALKINGA00:00:16
11710TRANSFERA00:00:00
11711TALKINGA00:01:52
11712RECEIVING_DROPA00:00:00

 

thanks for any help.

George

Labels (2)
2 Replies
Highlighted
Specialist II
Specialist II

Re: Multiple Grouping with conditions

You can use Set Analysis:

Condition grouping Group2 (Team): Find the team with the highest EventID (result Team 'A')

Max({<EventID={Max(EventID)}>}Team)


4. Condition within Group2: Find the highest EventID with EventType 'TALKING' and take its EventDuration time

Max({<EventType={'TALKING'}>}EventID)


5. Result schuld be: Team and its Talkingduration (EventDuration)

Table with Team, (the above 2 measures), EventDuration

 

Highlighted
Creator III
Creator III

Re: Multiple Grouping with conditions

Have some problems with your statement:

Max({<EventID={Max(EventID)}>}Team) is not working. Maybe you mean: 

Max({< EventId = { '$(=Max(EventId))' }>} Team)

 

Trying to put this information nested together, but dit not work. What is wrong?

Sum(
{<
EventId = {'$(=Max({< [EventType] = {'TALKING'}>} EventId ))'}, [EventDuration]
>}
[Team] )