<?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 Data variance in Qlikview in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Data-variance-in-Qlikview/m-p/667285#M541369</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I noticed some variances in my source data against Qlik's, Qlik is wrong, but only for selected few, most of the others are okay, and best of all, the total aggreated total is correct........really puzzling.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Below snapshot, top is&amp;nbsp; customer's current month sales total, and the bottom table is from the source data in MS Access for same month &amp;amp; year. &lt;SPAN style="color: #0000ff; font-size: 8pt;"&gt;&amp;nbsp; &lt;SPAN style="color: #000000;"&gt;Any advice? Thank you.&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #0000ff; font-size: 8pt;"&gt;Formula is : &lt;/SPAN&gt;sum&lt;SPAN style="font-size: 8pt;"&gt;(&lt;/SPAN&gt;&lt;SPAN style="color: #800000; font-size: 8pt;"&gt;[ACTUAL_SALES_AMT(JPY)]&lt;/SPAN&gt;&lt;SPAN style="font-size: 8pt;"&gt;) &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG alt="Capture.JPG" class="jive-image" src="https://community.qlik.com/legacyfs/online/62341_Capture.JPG" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG alt="Capture1.JPG" class="jive-image" src="https://community.qlik.com/legacyfs/online/62342_Capture1.JPG" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG alt="Capture2.JPG" class="jive-image" src="https://community.qlik.com/legacyfs/online/62343_Capture2.JPG" /&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Mon, 14 Jul 2014 03:30:32 GMT</pubDate>
    <dc:creator />
    <dc:date>2014-07-14T03:30:32Z</dc:date>
    <item>
      <title>Data variance in Qlikview</title>
      <link>https://community.qlik.com/t5/QlikView/Data-variance-in-Qlikview/m-p/667285#M541369</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I noticed some variances in my source data against Qlik's, Qlik is wrong, but only for selected few, most of the others are okay, and best of all, the total aggreated total is correct........really puzzling.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Below snapshot, top is&amp;nbsp; customer's current month sales total, and the bottom table is from the source data in MS Access for same month &amp;amp; year. &lt;SPAN style="color: #0000ff; font-size: 8pt;"&gt;&amp;nbsp; &lt;SPAN style="color: #000000;"&gt;Any advice? Thank you.&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #0000ff; font-size: 8pt;"&gt;Formula is : &lt;/SPAN&gt;sum&lt;SPAN style="font-size: 8pt;"&gt;(&lt;/SPAN&gt;&lt;SPAN style="color: #800000; font-size: 8pt;"&gt;[ACTUAL_SALES_AMT(JPY)]&lt;/SPAN&gt;&lt;SPAN style="font-size: 8pt;"&gt;) &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG alt="Capture.JPG" class="jive-image" src="https://community.qlik.com/legacyfs/online/62341_Capture.JPG" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG alt="Capture1.JPG" class="jive-image" src="https://community.qlik.com/legacyfs/online/62342_Capture1.JPG" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG alt="Capture2.JPG" class="jive-image" src="https://community.qlik.com/legacyfs/online/62343_Capture2.JPG" /&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 14 Jul 2014 03:30:32 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Data-variance-in-Qlikview/m-p/667285#M541369</guid>
      <dc:creator />
      <dc:date>2014-07-14T03:30:32Z</dc:date>
    </item>
    <item>
      <title>Re: Data variance in Qlikview</title>
      <link>https://community.qlik.com/t5/QlikView/Data-variance-in-Qlikview/m-p/667286#M541370</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;Share your application with current month data in scrambled format. It is difficult to investigate this without having application in hand.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 14 Jul 2014 03:51:24 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Data-variance-in-Qlikview/m-p/667286#M541370</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2014-07-14T03:51:24Z</dc:date>
    </item>
  </channel>
</rss>

