<?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 Create new column cumulated in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Create-new-column-cumulated/m-p/222075#M74821</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi to all, anybody knows how to create a new cumulated column ?&lt;/P&gt;&lt;P&gt;I tried to explain I have day stock and I want to create a new column that is the total stock as algebric sum&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;TABLE border="0" cellpadding="0" cellspacing="0" width="632"&gt;&lt;COL style="width: 90pt;" width="120" /&gt;&lt;COL style="width: 92pt;" width="123" /&gt;&lt;COL style="width: 120pt;" width="160" /&gt;&lt;COL style="width: 172pt;" width="229" /&gt;&lt;TBODY&gt;&lt;TR height="20" style="height: 15pt;"&gt;&lt;TD class="xl65" height="20" style="height: 15pt; width: 90pt;" width="120"&gt;Date&lt;/TD&gt;&lt;TD class="xl65" style="border-left: medium none; width: 92pt;" width="123"&gt;Day Stock&lt;BR /&gt;&lt;/TD&gt;&lt;TD class="xl65" style="border-left: medium none; width: 120pt;" width="160"&gt;TOTAL Stock&lt;/TD&gt;&lt;TD class="xl65" style="border-left: medium none; width: 172pt;" width="229"&gt;How to calulate&lt;/TD&gt;&lt;/TR&gt;&lt;TR height="20" style="height: 15pt;"&gt;&lt;TD align="right" class="xl66" height="20" style="height: 15pt; border-top: medium none;"&gt;01/01/2010&lt;/TD&gt;&lt;TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;"&gt;1&lt;/TD&gt;&lt;TD align="right" class="xl68" style="border-top: medium none; border-left: medium none;"&gt;1&lt;/TD&gt;&lt;TD class="xl67" style="border-top: medium none; border-left: medium none;"&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;TR height="20" style="height: 15pt;"&gt;&lt;TD align="right" class="xl66" height="20" style="height: 15pt; border-top: medium none;"&gt;02/01/2010&lt;/TD&gt;&lt;TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;"&gt;2&lt;/TD&gt;&lt;TD align="right" class="xl68" style="border-top: medium none; border-left: medium none;"&gt;3&lt;/TD&gt;&lt;TD class="xl67" style="border-top: medium none; border-left: medium none;"&gt;= today stock + prevous stock&lt;/TD&gt;&lt;/TR&gt;&lt;TR height="20" style="height: 15pt;"&gt;&lt;TD align="right" class="xl66" height="20" style="height: 15pt; border-top: medium none;"&gt;03/01/2010&lt;/TD&gt;&lt;TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;"&gt;3&lt;/TD&gt;&lt;TD align="right" class="xl68" style="border-top: medium none; border-left: medium none;"&gt;6&lt;/TD&gt;&lt;TD class="xl67" style="border-top: medium none; border-left: medium none;"&gt;= today stock + prevous stock&lt;/TD&gt;&lt;/TR&gt;&lt;TR height="20" style="height: 15pt;"&gt;&lt;TD align="right" class="xl66" height="20" style="height: 15pt; border-top: medium none;"&gt;04/01/2010&lt;/TD&gt;&lt;TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;"&gt;4&lt;/TD&gt;&lt;TD align="right" class="xl68" style="border-top: medium none; border-left: medium none;"&gt;10&lt;/TD&gt;&lt;TD class="xl67" style="border-top: medium none; border-left: medium none;"&gt;= today stock + prevous stock&lt;/TD&gt;&lt;/TR&gt;&lt;TR height="20" style="height: 15pt;"&gt;&lt;TD align="right" class="xl66" height="20" style="height: 15pt; border-top: medium none;"&gt;05/01/2010&lt;/TD&gt;&lt;TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;"&gt;-1&lt;/TD&gt;&lt;TD align="right" class="xl68" style="border-top: medium none; border-left: medium none;"&gt;9&lt;/TD&gt;&lt;TD class="xl67" style="border-top: medium none; border-left: medium none;"&gt;= today stock + prevous stock&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;If I select 4/1/2010 I want to see day stock = 4 Total Stock = 10&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks&lt;BR /&gt;Andrea&lt;/P&gt;&lt;TABLE border="0" cellpadding="0" cellspacing="0" style="height: 130px;" width="248"&gt;&lt;/TABLE&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Mon, 13 Dec 2010 22:44:35 GMT</pubDate>
    <dc:creator />
    <dc:date>2010-12-13T22:44:35Z</dc:date>
    <item>
      <title>Create new column cumulated</title>
      <link>https://community.qlik.com/t5/QlikView/Create-new-column-cumulated/m-p/222075#M74821</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi to all, anybody knows how to create a new cumulated column ?&lt;/P&gt;&lt;P&gt;I tried to explain I have day stock and I want to create a new column that is the total stock as algebric sum&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;TABLE border="0" cellpadding="0" cellspacing="0" width="632"&gt;&lt;COL style="width: 90pt;" width="120" /&gt;&lt;COL style="width: 92pt;" width="123" /&gt;&lt;COL style="width: 120pt;" width="160" /&gt;&lt;COL style="width: 172pt;" width="229" /&gt;&lt;TBODY&gt;&lt;TR height="20" style="height: 15pt;"&gt;&lt;TD class="xl65" height="20" style="height: 15pt; width: 90pt;" width="120"&gt;Date&lt;/TD&gt;&lt;TD class="xl65" style="border-left: medium none; width: 92pt;" width="123"&gt;Day Stock&lt;BR /&gt;&lt;/TD&gt;&lt;TD class="xl65" style="border-left: medium none; width: 120pt;" width="160"&gt;TOTAL Stock&lt;/TD&gt;&lt;TD class="xl65" style="border-left: medium none; width: 172pt;" width="229"&gt;How to calulate&lt;/TD&gt;&lt;/TR&gt;&lt;TR height="20" style="height: 15pt;"&gt;&lt;TD align="right" class="xl66" height="20" style="height: 15pt; border-top: medium none;"&gt;01/01/2010&lt;/TD&gt;&lt;TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;"&gt;1&lt;/TD&gt;&lt;TD align="right" class="xl68" style="border-top: medium none; border-left: medium none;"&gt;1&lt;/TD&gt;&lt;TD class="xl67" style="border-top: medium none; border-left: medium none;"&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;TR height="20" style="height: 15pt;"&gt;&lt;TD align="right" class="xl66" height="20" style="height: 15pt; border-top: medium none;"&gt;02/01/2010&lt;/TD&gt;&lt;TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;"&gt;2&lt;/TD&gt;&lt;TD align="right" class="xl68" style="border-top: medium none; border-left: medium none;"&gt;3&lt;/TD&gt;&lt;TD class="xl67" style="border-top: medium none; border-left: medium none;"&gt;= today stock + prevous stock&lt;/TD&gt;&lt;/TR&gt;&lt;TR height="20" style="height: 15pt;"&gt;&lt;TD align="right" class="xl66" height="20" style="height: 15pt; border-top: medium none;"&gt;03/01/2010&lt;/TD&gt;&lt;TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;"&gt;3&lt;/TD&gt;&lt;TD align="right" class="xl68" style="border-top: medium none; border-left: medium none;"&gt;6&lt;/TD&gt;&lt;TD class="xl67" style="border-top: medium none; border-left: medium none;"&gt;= today stock + prevous stock&lt;/TD&gt;&lt;/TR&gt;&lt;TR height="20" style="height: 15pt;"&gt;&lt;TD align="right" class="xl66" height="20" style="height: 15pt; border-top: medium none;"&gt;04/01/2010&lt;/TD&gt;&lt;TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;"&gt;4&lt;/TD&gt;&lt;TD align="right" class="xl68" style="border-top: medium none; border-left: medium none;"&gt;10&lt;/TD&gt;&lt;TD class="xl67" style="border-top: medium none; border-left: medium none;"&gt;= today stock + prevous stock&lt;/TD&gt;&lt;/TR&gt;&lt;TR height="20" style="height: 15pt;"&gt;&lt;TD align="right" class="xl66" height="20" style="height: 15pt; border-top: medium none;"&gt;05/01/2010&lt;/TD&gt;&lt;TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;"&gt;-1&lt;/TD&gt;&lt;TD align="right" class="xl68" style="border-top: medium none; border-left: medium none;"&gt;9&lt;/TD&gt;&lt;TD class="xl67" style="border-top: medium none; border-left: medium none;"&gt;= today stock + prevous stock&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;If I select 4/1/2010 I want to see day stock = 4 Total Stock = 10&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks&lt;BR /&gt;Andrea&lt;/P&gt;&lt;TABLE border="0" cellpadding="0" cellspacing="0" style="height: 130px;" width="248"&gt;&lt;/TABLE&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 13 Dec 2010 22:44:35 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Create-new-column-cumulated/m-p/222075#M74821</guid>
      <dc:creator />
      <dc:date>2010-12-13T22:44:35Z</dc:date>
    </item>
    <item>
      <title>Create new column cumulated</title>
      <link>https://community.qlik.com/t5/QlikView/Create-new-column-cumulated/m-p/222076#M74822</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Andrea,&lt;/P&gt;&lt;P&gt;if you want to perform this calculation in the load script look at functions "PEEK" and "PREVIOUS".&lt;/P&gt;&lt;P&gt;If you want to perform this in a chart, look at the "Accumulation" option for Chart Expressions, or at functions "Above" and "Before"&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 13 Dec 2010 22:50:42 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Create-new-column-cumulated/m-p/222076#M74822</guid>
      <dc:creator>Oleg_Troyansky</dc:creator>
      <dc:date>2010-12-13T22:50:42Z</dc:date>
    </item>
  </channel>
</rss>

