topic Pivot Chart - Sort by Multiple Regions in QlikView https://community.qlik.com/t5/QlikView/Pivot-Chart-Sort-by-Multiple-Regions/m-p/330656#M121751 <HTML><HEAD></HEAD><BODY><P>In QV, the sort is over global numbers so you can't have a different sort order of products being shown depending on the region in the same pivot table.&nbsp; You would have to divide it into 4 different pivot tables and use set analysis specify the region for each table.</P><P></P><P>Also, if this is important for you, vote on the idea to add it to QV (<A _jive_internal="true" href="https://community.qlik.com/ideas/http://community.qlik.com/ideas/1250#comment-2063">http://community.qlik.com/ideas/1250#comment-2063</A>)</P><P></P><P>Karl</P></BODY></HTML> Fri, 30 Mar 2012 20:59:47 GMT pover 2012-03-30T20:59:47Z Pivot Chart - Sort by Multiple Regions https://community.qlik.com/t5/QlikView/Pivot-Chart-Sort-by-Multiple-Regions/m-p/330655#M121750 <HTML><HEAD></HEAD><BODY><P>I'd like to see the top 20 Product Numbers ranked by Net Sales in each of our Retail Regions. We have 4 different Retail Regions, so in the end I want to see 80 Product Numbers ranked by Net Sales in descending order, and there should be 20 from each.</P><P></P><P>My Dimensions are Retail Region, Product Number, and Product Description.</P><P></P><P>I can't figure this out for the life of me. Thanks in advance for help and please ask any questions if I didn't offer enough info.</P><P></P><P>Thanks,</P><P>Mike</P></BODY></HTML> Fri, 30 Mar 2012 19:32:21 GMT https://community.qlik.com/t5/QlikView/Pivot-Chart-Sort-by-Multiple-Regions/m-p/330655#M121750 2012-03-30T19:32:21Z Pivot Chart - Sort by Multiple Regions https://community.qlik.com/t5/QlikView/Pivot-Chart-Sort-by-Multiple-Regions/m-p/330656#M121751 <HTML><HEAD></HEAD><BODY><P>In QV, the sort is over global numbers so you can't have a different sort order of products being shown depending on the region in the same pivot table.&nbsp; You would have to divide it into 4 different pivot tables and use set analysis specify the region for each table.</P><P></P><P>Also, if this is important for you, vote on the idea to add it to QV (<A _jive_internal="true" href="https://community.qlik.com/ideas/http://community.qlik.com/ideas/1250#comment-2063">http://community.qlik.com/ideas/1250#comment-2063</A>)</P><P></P><P>Karl</P></BODY></HTML> Fri, 30 Mar 2012 20:59:47 GMT https://community.qlik.com/t5/QlikView/Pivot-Chart-Sort-by-Multiple-Regions/m-p/330656#M121751 pover 2012-03-30T20:59:47Z