topic Re: Datewise status should sort in order in QlikView https://community.qlik.com/t5/QlikView/Datewise-status-should-sort-in-order/m-p/1354867#M415939 <HTML><HEAD></HEAD><BODY><P>Hi Rupali,</P><P>may be</P><P><SPAN style="color: #800000; font-size: 8pt;"><SPAN style="color: #000000; font-size: 10pt;">Concat</SPAN><SPAN style="color: #000000;">(DISTINCT NEW_VALUE,',',<SPAN style="color: #ff0000;">ROW_NUMBER</SPAN>) AS </SPAN><SPAN style="color: #000000; font-size: 8pt;">NEW_VALUE </SPAN></SPAN></P><P></P><P><SPAN style="color: #000000; font-size: 8pt;"><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/168017_pastedImage_8.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></P><P><SPAN style="color: #000000; font-size: 8pt;">Regards,</SPAN></P><P><SPAN style="color: #000000; font-size: 8pt;">Antonio</SPAN></P></BODY></HTML> Sat, 24 Jun 2017 17:38:01 GMT antoniotiman 2017-06-24T17:38:01Z Datewise status should sort in order https://community.qlik.com/t5/QlikView/Datewise-status-should-sort-in-order/m-p/1354866#M415938 <HTML><HEAD></HEAD><BODY><P>Hi Expert,</P><P></P><P>I have Row ID wise NEW VALUE and REC UPDATED DATE .My user want data must be concat and show in one column with ascending order.I can sort date but New value can not sort.It automatically sort by alphabetically order.Please suggest correct way .I have attached sample data.</P><P></P><P></P><P>Thanks in advance.</P><P>Rupali</P></BODY></HTML> Sat, 24 Jun 2017 17:12:39 GMT https://community.qlik.com/t5/QlikView/Datewise-status-should-sort-in-order/m-p/1354866#M415938 rupaliqlik 2017-06-24T17:12:39Z Re: Datewise status should sort in order https://community.qlik.com/t5/QlikView/Datewise-status-should-sort-in-order/m-p/1354867#M415939 <HTML><HEAD></HEAD><BODY><P>Hi Rupali,</P><P>may be</P><P><SPAN style="color: #800000; font-size: 8pt;"><SPAN style="color: #000000; font-size: 10pt;">Concat</SPAN><SPAN style="color: #000000;">(DISTINCT NEW_VALUE,',',<SPAN style="color: #ff0000;">ROW_NUMBER</SPAN>) AS </SPAN><SPAN style="color: #000000; font-size: 8pt;">NEW_VALUE </SPAN></SPAN></P><P></P><P><SPAN style="color: #000000; font-size: 8pt;"><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/168017_pastedImage_8.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></P><P><SPAN style="color: #000000; font-size: 8pt;">Regards,</SPAN></P><P><SPAN style="color: #000000; font-size: 8pt;">Antonio</SPAN></P></BODY></HTML> Sat, 24 Jun 2017 17:38:01 GMT https://community.qlik.com/t5/QlikView/Datewise-status-should-sort-in-order/m-p/1354867#M415939 antoniotiman 2017-06-24T17:38:01Z Re: Datewise status should sort in order https://community.qlik.com/t5/QlikView/Datewise-status-should-sort-in-order/m-p/1354868#M415940 <HTML><HEAD></HEAD><BODY><P>Thanks <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Sat, 24 Jun 2017 17:53:21 GMT https://community.qlik.com/t5/QlikView/Datewise-status-should-sort-in-order/m-p/1354868#M415940 rupaliqlik 2017-06-24T17:53:21Z