Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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 |
@rammuthiah What product are you using? QlikView or Qlik Sense?