https://community.qlik.com/t5/Water-Cooler/Ticket-Scenario/m-p/1672701#M11020 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/8795">@rammuthiah</a>&nbsp;What product are you using? QlikView or Qlik Sense?</P> Wed, 05 Feb 2020 20:53:03 GMT Sue_Macaluso 2020-02-05T20:53:03Z https://community.qlik.com/t5/Water-Cooler/Ticket-Scenario/m-p/1671552#M10985 <P>I have a scenario to solve as per below.</P> <TABLE width="242"> <TBODY> <TR> <TD width="64">AA</TD> <TD width="114">Accepted</TD> <TD width="64">TKT1</TD> </TR> <TR> <TD>AA</TD> <TD>Informed</TD> <TD>TKT2</TD> </TR> <TR> <TD>BB</TD> <TD>Assigned</TD> <TD>TKT3</TD> </TR> <TR> <TD>BB</TD> <TD>Pending Supplier</TD> <TD>TKT4</TD> </TR> <TR> <TD>BB</TD> <TD>Informed</TD> <TD>TKT5</TD> </TR> <TR> <TD>BB</TD> <TD>Informed</TD> <TD>TKT6</TD> </TR> <TR> <TD>CC</TD> <TD>Informed</TD> <TD>TKT7</TD> </TR> <TR> <TD>CC</TD> <TD>Pending Supplier</TD> <TD>TKT8</TD> </TR> <TR> <TD>DD</TD> <TD>Pending Customer</TD> <TD>TKT9</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>The output should be like below</P> <TABLE width="0"> <TBODY> <TR> <TD width="602"> <P>AA has 2 tickets whereas Accepted 1 and Informed 1 and the incidents are TKT1, TKT2</P> </TD> </TR> <TR> <TD width="602"> <P>BB has 4 tickets whereas Assigned 1, Pending Customer 1 and Informed 2 and the incidents are TKT3, TKT4, TKT5, TKT6</P> </TD> </TR> <TR> <TD width="602"> <P>CC has 2 tickets whereas Informed 1 and Pending Supplier 1 and the incidents are TKT7, TKT8</P> </TD> </TR> <TR> <TD width="602"> <P>DD has 2 tickets whereas Pending Customer 1 and the incidents are TKT9</P> </TD> </TR> </TBODY> </TABLE> Fri, 07 Feb 2020 22:35:10 GMT https://community.qlik.com/t5/Water-Cooler/Ticket-Scenario/m-p/1671552#M10985 rammuthiah 2020-02-07T22:35:10Z https://community.qlik.com/t5/Water-Cooler/Ticket-Scenario/m-p/1671554#M10986 <P>The output be like :</P><TABLE width="0"><TBODY><TR><TD width="602"><P>AA has 2 tickets whereas Accepted 1 and Informed 1 and the incidents are TKT1, TKT2</P></TD></TR><TR><TD width="602"><P>BB has 4 tickets whereas Assigned 1, Pending Customer 1 and Informed 2 and the incidents are TKT3, TKT4, TKT5, TKT6</P></TD></TR><TR><TD width="602"><P>CC has 2 tickets whereas Informed 1 and Pending Supplier 1 and the incidents are TKT7, TKT8</P></TD></TR><TR><TD width="602"><P>DD has 2 tickets whereas Pending Customer 1 and the incidents are TKT9</P></TD></TR></TBODY></TABLE> Sun, 02 Feb 2020 12:14:55 GMT https://community.qlik.com/t5/Water-Cooler/Ticket-Scenario/m-p/1671554#M10986 rammuthiah 2020-02-02T12:14:55Z https://community.qlik.com/t5/Water-Cooler/Ticket-Scenario/m-p/1672701#M11020 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/8795">@rammuthiah</a>&nbsp;What product are you using? QlikView or Qlik Sense?</P> Wed, 05 Feb 2020 20:53:03 GMT https://community.qlik.com/t5/Water-Cooler/Ticket-Scenario/m-p/1672701#M11020 Sue_Macaluso 2020-02-05T20:53:03Z