https://community.qlik.com/t5/App-Development/How-to-sort-the-data-in-chronological-order-in-the-pivot-table/m-p/1918341#M75517 <P>Hi Guys,</P> <P>How to sort the data in chronological order in the pivot table in Nprinting ? I tried multiple solution from the forum.</P> <P>But it doesn't seems to work for me , Below is the output I am getting. I want to asort it from Apr 2022 to Oct 2022.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="userpd_2021_0-1649847606473.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/76976i06FC29DEF21AD986/image-size/medium?v=v2&amp;px=400" role="button" title="userpd_2021_0-1649847606473.png" alt="userpd_2021_0-1649847606473.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="userpd_2021_1-1649847797204.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/76977iAAB05D3AFAED7325/image-size/medium?v=v2&amp;px=400" role="button" title="userpd_2021_1-1649847797204.png" alt="userpd_2021_1-1649847797204.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 14 Apr 2022 05:19:14 GMT userpd_2021 2022-04-14T05:19:14Z https://community.qlik.com/t5/App-Development/How-to-sort-the-data-in-chronological-order-in-the-pivot-table/m-p/1918341#M75517 <P>Hi Guys,</P> <P>How to sort the data in chronological order in the pivot table in Nprinting ? I tried multiple solution from the forum.</P> <P>But it doesn't seems to work for me , Below is the output I am getting. I want to asort it from Apr 2022 to Oct 2022.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="userpd_2021_0-1649847606473.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/76976i06FC29DEF21AD986/image-size/medium?v=v2&amp;px=400" role="button" title="userpd_2021_0-1649847606473.png" alt="userpd_2021_0-1649847606473.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="userpd_2021_1-1649847797204.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/76977iAAB05D3AFAED7325/image-size/medium?v=v2&amp;px=400" role="button" title="userpd_2021_1-1649847797204.png" alt="userpd_2021_1-1649847797204.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 14 Apr 2022 05:19:14 GMT https://community.qlik.com/t5/App-Development/How-to-sort-the-data-in-chronological-order-in-the-pivot-table/m-p/1918341#M75517 userpd_2021 2022-04-14T05:19:14Z https://community.qlik.com/t5/App-Development/How-to-sort-the-data-in-chronological-order-in-the-pivot-table/m-p/1918604#M75542 <P>It looked that your MonthYear isn't a numeric period-field else a string. This means you should create it properly within an auto-calendar or a master-calendar. See here for more background:</P> <P><A href="https://community.qlik.com/t5/QlikView-Documents/How-to-use-Master-Calendar-and-Date-Values/ta-p/1495741" target="_blank">How to use - Master-Calendar and Date-Values - Qlik Community - 1495741</A></P> <P>- Marcus</P> Thu, 14 Apr 2022 13:42:22 GMT https://community.qlik.com/t5/App-Development/How-to-sort-the-data-in-chronological-order-in-the-pivot-table/m-p/1918604#M75542 marcus_sommer 2022-04-14T13:42:22Z