<?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 Get Percentage per Month in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Get-Percentage-per-Month/m-p/1530271#M440618</link>
    <description>&lt;P&gt;Hello There,&lt;/P&gt;&lt;P&gt;Someone can guide how to apply this kind of format to Qlikview. See below some detailed.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sample layout.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/3741iABA346D6E09A21A3/image-size/medium?v=v2&amp;amp;px=400" role="button" title="sample layout.png" alt="sample layout.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;To get the percentage : This is the formula that i use&amp;nbsp;&lt;/P&gt;&lt;P&gt;(NOV|1TO30| 8,375,171.73 ) /&amp;nbsp; (OCT|REGULAR| 34,011,506.45 )&amp;nbsp; = NOV&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;24.62%&amp;nbsp;&lt;/P&gt;&lt;P&gt;Output:&lt;/P&gt;&lt;P&gt;NOV&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;24.62%&amp;nbsp;&amp;nbsp; &amp;nbsp;43.03%&amp;nbsp;&amp;nbsp; &amp;nbsp;48.48%&amp;nbsp;&amp;nbsp; &amp;nbsp;75.57%&amp;nbsp;&amp;nbsp; &amp;nbsp;4.28%&lt;BR /&gt;DEC&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;22.82%&amp;nbsp;&amp;nbsp; &amp;nbsp;46.29%&amp;nbsp;&amp;nbsp; &amp;nbsp;17.87%&amp;nbsp;&amp;nbsp; &amp;nbsp;120.39%&amp;nbsp;&amp;nbsp; &amp;nbsp;7.52%&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Best Regards,&lt;/P&gt;&lt;P&gt;Bing&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Tue, 15 Jan 2019 07:20:33 GMT</pubDate>
    <dc:creator>bsbernabe</dc:creator>
    <dc:date>2019-01-15T07:20:33Z</dc:date>
    <item>
      <title>Get Percentage per Month</title>
      <link>https://community.qlik.com/t5/QlikView/Get-Percentage-per-Month/m-p/1530271#M440618</link>
      <description>&lt;P&gt;Hello There,&lt;/P&gt;&lt;P&gt;Someone can guide how to apply this kind of format to Qlikview. See below some detailed.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sample layout.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/3741iABA346D6E09A21A3/image-size/medium?v=v2&amp;amp;px=400" role="button" title="sample layout.png" alt="sample layout.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;To get the percentage : This is the formula that i use&amp;nbsp;&lt;/P&gt;&lt;P&gt;(NOV|1TO30| 8,375,171.73 ) /&amp;nbsp; (OCT|REGULAR| 34,011,506.45 )&amp;nbsp; = NOV&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;24.62%&amp;nbsp;&lt;/P&gt;&lt;P&gt;Output:&lt;/P&gt;&lt;P&gt;NOV&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;24.62%&amp;nbsp;&amp;nbsp; &amp;nbsp;43.03%&amp;nbsp;&amp;nbsp; &amp;nbsp;48.48%&amp;nbsp;&amp;nbsp; &amp;nbsp;75.57%&amp;nbsp;&amp;nbsp; &amp;nbsp;4.28%&lt;BR /&gt;DEC&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;22.82%&amp;nbsp;&amp;nbsp; &amp;nbsp;46.29%&amp;nbsp;&amp;nbsp; &amp;nbsp;17.87%&amp;nbsp;&amp;nbsp; &amp;nbsp;120.39%&amp;nbsp;&amp;nbsp; &amp;nbsp;7.52%&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Best Regards,&lt;/P&gt;&lt;P&gt;Bing&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 15 Jan 2019 07:20:33 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Get-Percentage-per-Month/m-p/1530271#M440618</guid>
      <dc:creator>bsbernabe</dc:creator>
      <dc:date>2019-01-15T07:20:33Z</dc:date>
    </item>
  </channel>
</rss>

