topic Pivot table sorting by most recent period? in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-sorting-by-most-recent-period/m-p/608173#M477440 <HTML><HEAD></HEAD><BODY><P>I have built some pivot tables that look at products with sales by month (Jan-13, Feb-13 etc). I want to get it to sort by the most recent period's sales (or volume etc). So if you select 2014 it would show sales for Jan, Feb, March and April and I would want to sort by April (unless someone decided to select Jan, Feb and March only). </P><P></P><P>Is this actually possible in QlikView or am I going to have to instruct people to export to Excel and manually sort the columns they're interested in? </P></BODY></HTML> Wed, 23 Apr 2014 09:13:03 GMT Anonymous 2014-04-23T09:13:03Z Pivot table sorting by most recent period? https://community.qlik.com/t5/QlikView/Pivot-table-sorting-by-most-recent-period/m-p/608173#M477440 <HTML><HEAD></HEAD><BODY><P>I have built some pivot tables that look at products with sales by month (Jan-13, Feb-13 etc). I want to get it to sort by the most recent period's sales (or volume etc). So if you select 2014 it would show sales for Jan, Feb, March and April and I would want to sort by April (unless someone decided to select Jan, Feb and March only). </P><P></P><P>Is this actually possible in QlikView or am I going to have to instruct people to export to Excel and manually sort the columns they're interested in? </P></BODY></HTML> Wed, 23 Apr 2014 09:13:03 GMT https://community.qlik.com/t5/QlikView/Pivot-table-sorting-by-most-recent-period/m-p/608173#M477440 Anonymous 2014-04-23T09:13:03Z Re: Pivot table sorting by most recent period? https://community.qlik.com/t5/QlikView/Pivot-table-sorting-by-most-recent-period/m-p/608174#M477441 <HTML><HEAD></HEAD><BODY><P>Though pivot is not very friendly to sorting, I believe your requirement could be met. Try to share your qvw with sample data.</P></BODY></HTML> Wed, 23 Apr 2014 09:16:27 GMT https://community.qlik.com/t5/QlikView/Pivot-table-sorting-by-most-recent-period/m-p/608174#M477441 tresB 2014-04-23T09:16:27Z Re: Pivot table sorting by most recent period? https://community.qlik.com/t5/QlikView/Pivot-table-sorting-by-most-recent-period/m-p/608175#M477442 <HTML><HEAD></HEAD><BODY><P>How do I share a QVW?</P></BODY></HTML> Wed, 23 Apr 2014 09:19:16 GMT https://community.qlik.com/t5/QlikView/Pivot-table-sorting-by-most-recent-period/m-p/608175#M477442 Anonymous 2014-04-23T09:19:16Z Re: Re: Pivot table sorting by most recent period? https://community.qlik.com/t5/QlikView/Pivot-table-sorting-by-most-recent-period/m-p/608176#M477443 <HTML><HEAD></HEAD><BODY><P>Reply-&gt; 'Use dvanced editor' (top right corner of your edit window)-&gt; 'Attach' (bottom right corner).</P><P>And see: <A href="http://community.qlik.com/docs/DOC-1290" title="http://community.qlik.com/docs/DOC-1290">Preparing examples for Upload - Reduction and D... | Qlik Community</A></P></BODY></HTML> Wed, 23 Apr 2014 09:47:07 GMT https://community.qlik.com/t5/QlikView/Pivot-table-sorting-by-most-recent-period/m-p/608176#M477443 tresB 2014-04-23T09:47:07Z