<?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 AW:Calculated Field (Table) in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Calculated-Field-Table/m-p/231720#M83427</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;can you upload a Example?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Fri, 08 Oct 2010 08:08:40 GMT</pubDate>
    <dc:creator />
    <dc:date>2010-10-08T08:08:40Z</dc:date>
    <item>
      <title>Calculated Field (Table)</title>
      <link>https://community.qlik.com/t5/QlikView/Calculated-Field-Table/m-p/231719#M83426</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi together,&lt;/P&gt;&lt;P&gt;I have the following issue:&lt;/P&gt;&lt;P&gt;I have two concatenated tables&lt;/P&gt;&lt;P&gt;Type ID Date Ammount&lt;/P&gt;&lt;P&gt;1 001 01/10/2010 102&lt;/P&gt;&lt;P&gt;1 001 10/10/2010 56&lt;/P&gt;&lt;P&gt;1 002 02/10/2010 85&lt;/P&gt;&lt;P&gt;2 001 05/10/2010 100&lt;/P&gt;&lt;P&gt;2 002 03/10/2010 200&lt;/P&gt;&lt;P&gt;1 001 01/09/2010 55&lt;/P&gt;&lt;P&gt;.........&lt;/P&gt;&lt;P&gt;So I want to create new table with the same structure and Ammount=sum(ammount) where Type=2 - sum(ammount) where Type=1 for every month&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 08 Oct 2010 07:45:35 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Calculated-Field-Table/m-p/231719#M83426</guid>
      <dc:creator />
      <dc:date>2010-10-08T07:45:35Z</dc:date>
    </item>
    <item>
      <title>AW:Calculated Field (Table)</title>
      <link>https://community.qlik.com/t5/QlikView/Calculated-Field-Table/m-p/231720#M83427</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;can you upload a Example?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 08 Oct 2010 08:08:40 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Calculated-Field-Table/m-p/231720#M83427</guid>
      <dc:creator />
      <dc:date>2010-10-08T08:08:40Z</dc:date>
    </item>
  </channel>
</rss>

