topic Blank rows sort order in pivot table in QlikView https://community.qlik.com/t5/QlikView/Blank-rows-sort-order-in-pivot-table/m-p/1216644#M870867 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>We are using pivot table and we need to sort the data like the market which don't have data should be come in the bottom of the report.</P><P>We have sort the market in descending but still&nbsp; one market is not sorted.</P><P>Please let me know hot to get this.</P><P>The marked one in the below image need to display in the bottom of the report.</P><P></P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/144642_Untitled.png" style="height: 208px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT nareshthavidishetty 2020-11-25T16:16:04Z Blank rows sort order in pivot table https://community.qlik.com/t5/QlikView/Blank-rows-sort-order-in-pivot-table/m-p/1216644#M870867 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>We are using pivot table and we need to sort the data like the market which don't have data should be come in the bottom of the report.</P><P>We have sort the market in descending but still&nbsp; one market is not sorted.</P><P>Please let me know hot to get this.</P><P>The marked one in the below image need to display in the bottom of the report.</P><P></P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/144642_Untitled.png" style="height: 208px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Blank-rows-sort-order-in-pivot-table/m-p/1216644#M870867 nareshthavidishetty 2020-11-25T16:16:04Z Re: Blank rows sort order in pivot table https://community.qlik.com/t5/QlikView/Blank-rows-sort-order-in-pivot-table/m-p/1216645#M870868 <HTML><HEAD></HEAD><BODY><P>How about responding to your original thread and not duplicating them?</P><P></P><P><A href="https://community.qlik.com/thread/240077">Pivot table blank rows sort</A></P></BODY></HTML> Wed, 23 Nov 2016 13:49:29 GMT https://community.qlik.com/t5/QlikView/Blank-rows-sort-order-in-pivot-table/m-p/1216645#M870868 adamdavi3s 2016-11-23T13:49:29Z