Qlik Community

Community Corner

Discussion board for questions about the Qlik Community, its features, sharing information, general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Ticket Scenario

I have a scenario to solve as per below.

AA Accepted TKT1
AA Informed TKT2
BB Assigned TKT3
BB Pending Supplier TKT4
BB Informed TKT5
BB Informed TKT6
CC Informed TKT7
CC Pending Supplier TKT8
DD Pending Customer TKT9

 

The output should be like below

AA has 2 tickets whereas Accepted 1 and Informed 1 and the incidents are TKT1, TKT2

BB has 4 tickets whereas Assigned 1, Pending Customer 1 and Informed 2 and the incidents are TKT3, TKT4, TKT5, TKT6

CC has 2 tickets whereas Informed 1 and Pending Supplier 1 and the incidents are TKT7, TKT8

DD has 2 tickets whereas Pending Customer 1 and the incidents are TKT9

Labels (1)
2 Replies
Highlighted
Creator II
Creator II

The output be like :

AA has 2 tickets whereas Accepted 1 and Informed 1 and the incidents are TKT1, TKT2

BB has 4 tickets whereas Assigned 1, Pending Customer 1 and Informed 2 and the incidents are TKT3, TKT4, TKT5, TKT6

CC has 2 tickets whereas Informed 1 and Pending Supplier 1 and the incidents are TKT7, TKT8

DD has 2 tickets whereas Pending Customer 1 and the incidents are TKT9

Highlighted
Community Manager
Community Manager

@rammuthiah What product are you using? QlikView or Qlik Sense?

Sue Macaluso