<?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 Input sum function - distribution mode '/' in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Input-sum-function-distribution-mode/m-p/1106015#M366307</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Can some one please explain how the Input sum with distribution mode &lt;STRONG&gt;'/'&lt;/STRONG&gt; works?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I do not understand the below explanation from the help manual:&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;"&gt;The value is divided equally between underlying values, &lt;STRONG&gt;without regard to previous distribution but keeping previous sum.&lt;/STRONG&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;"&gt;For example, I have an Year 2001 with Jan Sales 100, Feb Sales 100 and March Sales 100. I am using a inputsum( Sum(Sales),'/') as expression and Year as dimension in a straight table and then changing the value from 300 (100+100+100) to 400. How this value will get distributed among Jan, Feb and March?&lt;STRONG&gt;&lt;BR /&gt;&lt;/STRONG&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;"&gt;&lt;STRONG&gt;&lt;BR /&gt;&lt;/STRONG&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;"&gt;Thanks in advance for your help.&lt;STRONG&gt;&lt;BR /&gt;&lt;/STRONG&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Fri, 24 Jun 2016 03:49:49 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2016-06-24T03:49:49Z</dc:date>
    <item>
      <title>Input sum function - distribution mode '/'</title>
      <link>https://community.qlik.com/t5/QlikView/Input-sum-function-distribution-mode/m-p/1106015#M366307</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Can some one please explain how the Input sum with distribution mode &lt;STRONG&gt;'/'&lt;/STRONG&gt; works?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I do not understand the below explanation from the help manual:&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;"&gt;The value is divided equally between underlying values, &lt;STRONG&gt;without regard to previous distribution but keeping previous sum.&lt;/STRONG&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;"&gt;For example, I have an Year 2001 with Jan Sales 100, Feb Sales 100 and March Sales 100. I am using a inputsum( Sum(Sales),'/') as expression and Year as dimension in a straight table and then changing the value from 300 (100+100+100) to 400. How this value will get distributed among Jan, Feb and March?&lt;STRONG&gt;&lt;BR /&gt;&lt;/STRONG&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;"&gt;&lt;STRONG&gt;&lt;BR /&gt;&lt;/STRONG&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;"&gt;Thanks in advance for your help.&lt;STRONG&gt;&lt;BR /&gt;&lt;/STRONG&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 24 Jun 2016 03:49:49 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Input-sum-function-distribution-mode/m-p/1106015#M366307</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2016-06-24T03:49:49Z</dc:date>
    </item>
  </channel>
</rss>

