<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>idea Pivot Table - Sorting with Column Dimension and Totals in Suggest an Idea</title>
    <link>https://community.qlik.com/t5/Suggest-an-Idea/Pivot-Table-Sorting-with-Column-Dimension-and-Totals/idi-p/1825080</link>
    <description>&lt;P&gt;Currently sorting using 'Sort by first measure' does not work properly when using one dimension on Column and multiple dimensions on Row.&lt;/P&gt;&lt;P&gt;When we enable Show Totals on every dimension and then enable 'Sort by first measure' with every Dimension in Row the Sorting will work properly:&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="qlik pivot Row Dimensions.png" style="width: 867px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/59288iF372A48C9089B63C/image-size/large?v=v2&amp;amp;px=999" role="button" title="qlik pivot Row Dimensions.png" alt="qlik pivot Row Dimensions.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;When we then move our Mix dimension to Column dimension, the sorting breaks:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="qlik pivot Column.png" style="width: 873px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/59289i2100519EBC20FAD8/image-size/large?v=v2&amp;amp;px=999" role="button" title="qlik pivot Column.png" alt="qlik pivot Column.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Our client wants to always be able to Sort everything Descending also when using the Column dimension (working with only Row dimensions is not an option).&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Also discussed with Qlik Support:&lt;/P&gt;&lt;P&gt;Case Details&lt;/P&gt;&lt;P&gt;&lt;SPAN class="subtitle"&gt;02221314 - Sorting in Pivot with Totals and Multiple dimensions &lt;/SPAN&gt;&lt;/P&gt;</description>
    <pubDate>Wed, 28 Jul 2021 08:46:31 GMT</pubDate>
    <dc:creator>JPT</dc:creator>
    <dc:date>2021-07-28T08:46:31Z</dc:date>
    <item>
      <title>Re: Pivot Table - Sorting with Column Dimension and Totals</title>
      <link>https://community.qlik.com/t5/Suggest-an-Idea/Pivot-Table-Sorting-with-Column-Dimension-and-Totals/idc-p/1825124#M6882</link>
      <description>&lt;P&gt;Hello,&lt;BR /&gt;there is a fundamental error in your interpretation of the ordering of the columns.&lt;BR /&gt;The columns are actually ordered.&lt;BR /&gt;You have to add up the whole description "A" of each group (in "Mix", "Continent", "Country" and in "Client").&lt;BR /&gt;If you wish and you want to try your hand in Italian (!!), here you will find all the description and a way to allow users to sort the columns in the Pivot;&lt;BR /&gt;&lt;A href="https://www.qlikclips.it/sort-sulle-pivot-2/" target="_blank" rel="noopener"&gt;https://www.qlikclips.it/sort-sulle-pivot-2/&lt;/A&gt;&lt;/P&gt;</description>
      <pubDate>Wed, 28 Jul 2021 10:28:20 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Suggest-an-Idea/Pivot-Table-Sorting-with-Column-Dimension-and-Totals/idc-p/1825124#M6882</guid>
      <dc:creator>Marcoimp</dc:creator>
      <dc:date>2021-07-28T10:28:20Z</dc:date>
    </item>
    <item>
      <title>Re: Pivot Table - Sorting with Column Dimension and Totals - Status changed to: Closed - Already Available</title>
      <link>https://community.qlik.com/t5/Suggest-an-Idea/Pivot-Table-Sorting-with-Column-Dimension-and-Totals/idc-p/1829113#M7055</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/126778"&gt;@JPT&lt;/a&gt;&amp;nbsp;, thank you for submitting. The pivot table sorting is working as designed and you are able to further order your columns using the information from&amp;nbsp;&lt;a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/35959"&gt;@Marcoimp&lt;/a&gt;&amp;nbsp;. As I think we could help further with this I suggest resubmitting as a problem in the &lt;A href="https://community.qlik.com/t5/App-Development/bd-p/qlik-sense-app-development" target="_self"&gt;Qlik Sense App Development&lt;/A&gt; Forum where community users can help you get the proper sorting for your customer.&lt;/P&gt;
&lt;P&gt;Meghann&lt;/P&gt;</description>
      <pubDate>Tue, 17 Aug 2021 15:05:12 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Suggest-an-Idea/Pivot-Table-Sorting-with-Column-Dimension-and-Totals/idc-p/1829113#M7055</guid>
      <dc:creator>Meghann_MacDonald</dc:creator>
      <dc:date>2021-08-17T15:05:12Z</dc:date>
    </item>
  </channel>
</rss>

