<?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 Re: expr correction? in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/expr-correction/m-p/788717#M1040501</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;got it &lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Fri, 26 Dec 2014 07:35:13 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2014-12-26T07:35:13Z</dc:date>
    <item>
      <title>expr correction?</title>
      <link>https://community.qlik.com/t5/QlikView/expr-correction/m-p/788716#M1040500</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;avg({&amp;lt;period={'&amp;gt;$(=date($(vmaxperiod)-$(vdays))) &amp;lt;=$(=date($(vmaxperiod)))'} &amp;gt;}merticvalue/(100000))&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;-(minus)&lt;/P&gt;&lt;P&gt;avg({&amp;lt;period={'&amp;gt;$(=date($(vmaxperiod)-$(vdays))) &amp;lt;=$(=date($(vmaxperiod)))'} &amp;gt;}previousmerticvalue/(100000))&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;here&lt;/P&gt;&lt;P&gt;ex:&lt;/P&gt;&lt;P&gt; metricvalue:&lt;/P&gt;&lt;P&gt;day1,100&lt;/P&gt;&lt;P&gt;day2,200&lt;/P&gt;&lt;P&gt;day3,300&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;previous metric value means i want like&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;metric value is day1&amp;nbsp;&amp;nbsp; then previous metric value is 0&lt;/P&gt;&lt;P&gt;metric value is day2&amp;nbsp;&amp;nbsp; then previous metric value is 1&lt;/P&gt;&lt;P&gt;metric value is day3&amp;nbsp;&amp;nbsp; then previous metric value is 2&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;i have only field is metricvalue&amp;nbsp;&amp;nbsp; from this i have calculate prvious metric value&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;i have tried above function its not working&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;give me some idea when&amp;nbsp; metricvalue is day1 iwant prev metricvalue is 0&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;metricvalue is day2 iwant prev metricvalue is day1&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;metricvalue is day3 iwant prev metricvalue is day2&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 26 Dec 2014 07:04:36 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/expr-correction/m-p/788716#M1040500</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2014-12-26T07:04:36Z</dc:date>
    </item>
    <item>
      <title>Re: expr correction?</title>
      <link>https://community.qlik.com/t5/QlikView/expr-correction/m-p/788717#M1040501</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;got it &lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 26 Dec 2014 07:35:13 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/expr-correction/m-p/788717#M1040501</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2014-12-26T07:35:13Z</dc:date>
    </item>
  </channel>
</rss>

