topic Re: How to convert long table to short table in QlikView https://community.qlik.com/t5/QlikView/How-to-convert-long-table-to-short-table/m-p/40192#M777365 <HTML><HEAD></HEAD><BODY><P>Or if you want to do this in the straight table</P><P></P><P>dimension: customer_Id</P><P>expression : concat(ORDER_ID,',')</P></BODY></HTML> Wed, 02 May 2018 17:35:50 GMT sasiparupudi1 2018-05-02T17:35:50Z How to convert long table to short table https://community.qlik.com/t5/QlikView/How-to-convert-long-table-to-short-table/m-p/40190#M777363 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>Any one help me to do long table to short table in Qlikview . Please check the below image of scenario.</P><P></P><P>Thanks in advance.</P><P></P><P></P><P></P><P><IMG __jive_id="201216" alt="111.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/201216_111.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-convert-long-table-to-short-table/m-p/40190#M777363 debabrata_sahoo 2020-11-25T16:16:04Z Re: How to convert long table to short table https://community.qlik.com/t5/QlikView/How-to-convert-long-table-to-short-table/m-p/40191#M777364 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>LOAD CUSTOMER_NUMBER,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Concat(DISTINCT ORDER_ID, ',') as ORDER_ID</STRONG></P><P><STRONG>FROM ...</STRONG></P><P><STRONG>Group By CUSTOMER_NUMBER;</STRONG></P></BODY></HTML> Wed, 02 May 2018 16:49:33 GMT https://community.qlik.com/t5/QlikView/How-to-convert-long-table-to-short-table/m-p/40191#M777364 sunny_talwar 2018-05-02T16:49:33Z Re: How to convert long table to short table https://community.qlik.com/t5/QlikView/How-to-convert-long-table-to-short-table/m-p/40192#M777365 <HTML><HEAD></HEAD><BODY><P>Or if you want to do this in the straight table</P><P></P><P>dimension: customer_Id</P><P>expression : concat(ORDER_ID,',')</P></BODY></HTML> Wed, 02 May 2018 17:35:50 GMT https://community.qlik.com/t5/QlikView/How-to-convert-long-table-to-short-table/m-p/40192#M777365 sasiparupudi1 2018-05-02T17:35:50Z Re: How to convert long table to short table https://community.qlik.com/t5/QlikView/How-to-convert-long-table-to-short-table/m-p/40193#M777366 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>‌ . Thank you.</P></BODY></HTML> Thu, 03 May 2018 04:02:13 GMT https://community.qlik.com/t5/QlikView/How-to-convert-long-table-to-short-table/m-p/40193#M777366 debabrata_sahoo 2018-05-03T04:02:13Z Re: How to convert long table to short table https://community.qlik.com/t5/QlikView/How-to-convert-long-table-to-short-table/m-p/40194#M777367 <HTML><HEAD></HEAD><BODY><P>@<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 20px; font-weight: bold;">Sasidhar Parupudi&nbsp; </SPAN><SPAN style="font-size: 10pt;"><STRONG>Thank you for your reply.</STRONG></SPAN></P></BODY></HTML> Thu, 03 May 2018 04:05:38 GMT https://community.qlik.com/t5/QlikView/How-to-convert-long-table-to-short-table/m-p/40194#M777367 debabrata_sahoo 2018-05-03T04:05:38Z