<?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>topic Sort percentages on stacked bar charts in App Development</title>
    <link>https://community.qlik.com/t5/App-Development/Sort-percentages-on-stacked-bar-charts/m-p/1779524#M60595</link>
    <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have a stacked bar chart by country dimension and a Sales percentage measure ( calculated using two metrics, numerator and denominator) .&amp;nbsp;&lt;/P&gt;&lt;P&gt;Each country bar is further stacked by another indicator dimension ( For e.g., Y and N) . So at for Country = USA we will have Y as 60 % on the bar and remaining 40 % as N.&lt;/P&gt;&lt;P&gt;The problem happens during the sort. I am sorting by expression DESCENDING on Country dimension . That expression is =$(eSales%) . The stacked bar chart&amp;nbsp; doesn't respect the DESC order . Not sure how do I fix this?&lt;/P&gt;&lt;P&gt;eSales% is a variable and that calculation has numerator and denominator.&amp;nbsp;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Mon, 20 Dec 2021 21:05:46 GMT</pubDate>
    <dc:creator>PrashantRupani</dc:creator>
    <dc:date>2021-12-20T21:05:46Z</dc:date>
    <item>
      <title>Sort percentages on stacked bar charts</title>
      <link>https://community.qlik.com/t5/App-Development/Sort-percentages-on-stacked-bar-charts/m-p/1779524#M60595</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have a stacked bar chart by country dimension and a Sales percentage measure ( calculated using two metrics, numerator and denominator) .&amp;nbsp;&lt;/P&gt;&lt;P&gt;Each country bar is further stacked by another indicator dimension ( For e.g., Y and N) . So at for Country = USA we will have Y as 60 % on the bar and remaining 40 % as N.&lt;/P&gt;&lt;P&gt;The problem happens during the sort. I am sorting by expression DESCENDING on Country dimension . That expression is =$(eSales%) . The stacked bar chart&amp;nbsp; doesn't respect the DESC order . Not sure how do I fix this?&lt;/P&gt;&lt;P&gt;eSales% is a variable and that calculation has numerator and denominator.&amp;nbsp;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 20 Dec 2021 21:05:46 GMT</pubDate>
      <guid>https://community.qlik.com/t5/App-Development/Sort-percentages-on-stacked-bar-charts/m-p/1779524#M60595</guid>
      <dc:creator>PrashantRupani</dc:creator>
      <dc:date>2021-12-20T21:05:46Z</dc:date>
    </item>
  </channel>
</rss>

