<?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 Problem with sum in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Problem-with-sum/m-p/180924#M47159</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Dear all&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have a big problem and i have not idea how to solve it.&lt;/P&gt;&lt;P&gt;I have a pivot table with a sum function, I have selected only one record and sum is double of the value.&lt;/P&gt;&lt;P&gt;If I put field as dimension i can show that it's different,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Here's an example&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;TABLE border="0" cellpadding="0" cellspacing="0" style="width: 180pt; border-collapse: collapse;" width="240"&gt;&lt;COLGROUP&gt;&lt;COL span="3" style="width: 60pt;" width="80" /&gt;&lt;/COLGROUP&gt;&lt;TBODY&gt;&lt;TR height="48" style="height: 36pt;"&gt;&lt;TD class="xl24" height="48" style="background-color: white; width: 60pt; height: 36pt; border: white 0.5pt solid;" width="80"&gt;&lt;STRONG&gt;PES&lt;/STRONG&gt;&lt;/TD&gt;&lt;TD class="xl25" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; width: 60pt; border-top: white 0.5pt solid; border-right: white 0.5pt solid;" width="80"&gt;COUNT&lt;/TD&gt;&lt;TD class="xl25" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; width: 60pt; border-top: white 0.5pt solid; border-right: white 0.5pt solid;" width="80"&gt;SUM(PES)&lt;/TD&gt;&lt;/TR&gt;&lt;TR height="17" style="height: 12.75pt;"&gt;&lt;TD class="xl26" height="17" style="border-bottom: white 0.5pt solid; border-left: white 0.5pt solid; background-color: white; width: 60pt; height: 12.75pt; border-top: white; border-right: white 0.5pt solid;" width="80"&gt;1950&lt;/TD&gt;&lt;TD class="xl26" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; width: 60pt; border-top: white; border-right: white 0.5pt solid;" width="80"&gt;1&lt;/TD&gt;&lt;TD class="xl26" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; width: 60pt; border-top: white; border-right: white 0.5pt solid;" width="80"&gt;3900&lt;/TD&gt;&lt;/TR&gt;&lt;TR height="17" style="height: 12.75pt;"&gt;&lt;TD height="17" style="background-color: transparent; height: 12.75pt; border: #ece9d8;"&gt;&lt;/TD&gt;&lt;TD style="background-color: transparent; border: #ece9d8;"&gt;&lt;/TD&gt;&lt;TD style="background-color: transparent; border: #ece9d8;"&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;BR /&gt;&lt;BR /&gt; &lt;P&gt;But if I put the expression without sum it returns correct value.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;TABLE border="0" cellpadding="0" cellspacing="0" style="width: 180pt; border-collapse: collapse;" width="240"&gt;&lt;COLGROUP&gt;&lt;COL span="3" style="width: 60pt;" width="80" /&gt;&lt;/COLGROUP&gt;&lt;TBODY&gt;&lt;TR height="48" style="height: 36pt;"&gt;&lt;TD class="xl24" height="48" style="background-color: white; width: 60pt; height: 36pt; border: white 0.5pt solid;" width="80"&gt;&lt;STRONG&gt;PES&lt;/STRONG&gt;&lt;/TD&gt;&lt;TD class="xl25" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; width: 60pt; border-top: white 0.5pt solid; border-right: white 0.5pt solid;" width="80"&gt;COUNT&lt;/TD&gt;&lt;TD class="xl25" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; width: 60pt; border-top: white 0.5pt solid; border-right: white 0.5pt solid;" width="80"&gt;PES&lt;/TD&gt;&lt;/TR&gt;&lt;TR height="17" style="height: 12.75pt;"&gt;&lt;TD class="xl26" height="17" style="border-bottom: white 0.5pt solid; border-left: white 0.5pt solid; background-color: white; width: 60pt; height: 12.75pt; border-top: white; border-right: white 0.5pt solid;" width="80"&gt;1950&lt;/TD&gt;&lt;TD class="xl26" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; width: 60pt; border-top: white; border-right: white 0.5pt solid;" width="80"&gt;1&lt;/TD&gt;&lt;TD class="xl26" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; width: 60pt; border-top: white; border-right: white 0.5pt solid;" width="80"&gt;1950&lt;/TD&gt;&lt;/TR&gt;&lt;TR height="17" style="height: 12.75pt;"&gt;&lt;TD height="17" style="background-color: transparent; height: 12.75pt; border: #ece9d8;"&gt;&lt;/TD&gt;&lt;TD style="background-color: transparent; border: #ece9d8;"&gt;&lt;/TD&gt;&lt;TD style="background-color: transparent; border: #ece9d8;"&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;BR /&gt;&lt;BR /&gt; &lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Problem is to solve that because it must be a sum. I'm doing only with one record to found error&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks for your help&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Tue, 08 Jun 2010 14:58:04 GMT</pubDate>
    <dc:creator />
    <dc:date>2010-06-08T14:58:04Z</dc:date>
    <item>
      <title>Problem with sum</title>
      <link>https://community.qlik.com/t5/QlikView/Problem-with-sum/m-p/180924#M47159</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Dear all&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have a big problem and i have not idea how to solve it.&lt;/P&gt;&lt;P&gt;I have a pivot table with a sum function, I have selected only one record and sum is double of the value.&lt;/P&gt;&lt;P&gt;If I put field as dimension i can show that it's different,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Here's an example&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;TABLE border="0" cellpadding="0" cellspacing="0" style="width: 180pt; border-collapse: collapse;" width="240"&gt;&lt;COLGROUP&gt;&lt;COL span="3" style="width: 60pt;" width="80" /&gt;&lt;/COLGROUP&gt;&lt;TBODY&gt;&lt;TR height="48" style="height: 36pt;"&gt;&lt;TD class="xl24" height="48" style="background-color: white; width: 60pt; height: 36pt; border: white 0.5pt solid;" width="80"&gt;&lt;STRONG&gt;PES&lt;/STRONG&gt;&lt;/TD&gt;&lt;TD class="xl25" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; width: 60pt; border-top: white 0.5pt solid; border-right: white 0.5pt solid;" width="80"&gt;COUNT&lt;/TD&gt;&lt;TD class="xl25" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; width: 60pt; border-top: white 0.5pt solid; border-right: white 0.5pt solid;" width="80"&gt;SUM(PES)&lt;/TD&gt;&lt;/TR&gt;&lt;TR height="17" style="height: 12.75pt;"&gt;&lt;TD class="xl26" height="17" style="border-bottom: white 0.5pt solid; border-left: white 0.5pt solid; background-color: white; width: 60pt; height: 12.75pt; border-top: white; border-right: white 0.5pt solid;" width="80"&gt;1950&lt;/TD&gt;&lt;TD class="xl26" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; width: 60pt; border-top: white; border-right: white 0.5pt solid;" width="80"&gt;1&lt;/TD&gt;&lt;TD class="xl26" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; width: 60pt; border-top: white; border-right: white 0.5pt solid;" width="80"&gt;3900&lt;/TD&gt;&lt;/TR&gt;&lt;TR height="17" style="height: 12.75pt;"&gt;&lt;TD height="17" style="background-color: transparent; height: 12.75pt; border: #ece9d8;"&gt;&lt;/TD&gt;&lt;TD style="background-color: transparent; border: #ece9d8;"&gt;&lt;/TD&gt;&lt;TD style="background-color: transparent; border: #ece9d8;"&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;BR /&gt;&lt;BR /&gt; &lt;P&gt;But if I put the expression without sum it returns correct value.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;TABLE border="0" cellpadding="0" cellspacing="0" style="width: 180pt; border-collapse: collapse;" width="240"&gt;&lt;COLGROUP&gt;&lt;COL span="3" style="width: 60pt;" width="80" /&gt;&lt;/COLGROUP&gt;&lt;TBODY&gt;&lt;TR height="48" style="height: 36pt;"&gt;&lt;TD class="xl24" height="48" style="background-color: white; width: 60pt; height: 36pt; border: white 0.5pt solid;" width="80"&gt;&lt;STRONG&gt;PES&lt;/STRONG&gt;&lt;/TD&gt;&lt;TD class="xl25" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; width: 60pt; border-top: white 0.5pt solid; border-right: white 0.5pt solid;" width="80"&gt;COUNT&lt;/TD&gt;&lt;TD class="xl25" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; width: 60pt; border-top: white 0.5pt solid; border-right: white 0.5pt solid;" width="80"&gt;PES&lt;/TD&gt;&lt;/TR&gt;&lt;TR height="17" style="height: 12.75pt;"&gt;&lt;TD class="xl26" height="17" style="border-bottom: white 0.5pt solid; border-left: white 0.5pt solid; background-color: white; width: 60pt; height: 12.75pt; border-top: white; border-right: white 0.5pt solid;" width="80"&gt;1950&lt;/TD&gt;&lt;TD class="xl26" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; width: 60pt; border-top: white; border-right: white 0.5pt solid;" width="80"&gt;1&lt;/TD&gt;&lt;TD class="xl26" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; width: 60pt; border-top: white; border-right: white 0.5pt solid;" width="80"&gt;1950&lt;/TD&gt;&lt;/TR&gt;&lt;TR height="17" style="height: 12.75pt;"&gt;&lt;TD height="17" style="background-color: transparent; height: 12.75pt; border: #ece9d8;"&gt;&lt;/TD&gt;&lt;TD style="background-color: transparent; border: #ece9d8;"&gt;&lt;/TD&gt;&lt;TD style="background-color: transparent; border: #ece9d8;"&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;BR /&gt;&lt;BR /&gt; &lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Problem is to solve that because it must be a sum. I'm doing only with one record to found error&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks for your help&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 08 Jun 2010 14:58:04 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Problem-with-sum/m-p/180924#M47159</guid>
      <dc:creator />
      <dc:date>2010-06-08T14:58:04Z</dc:date>
    </item>
    <item>
      <title>Problem with sum</title>
      <link>https://community.qlik.com/t5/QlikView/Problem-with-sum/m-p/180925#M47160</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Probably you have a two records about that dimensions.......&lt;/P&gt;&lt;P&gt;....we need check you model....if you can......put here to check....&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 08 Jun 2010 15:15:45 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Problem-with-sum/m-p/180925#M47160</guid>
      <dc:creator />
      <dc:date>2010-06-08T15:15:45Z</dc:date>
    </item>
  </channel>
</rss>

