<?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: YTD Issue in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/YTD-Issue/m-p/980781#M967860</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Check script and Bar Chart expressions from enclosed file..&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Fri, 18 Sep 2015 15:14:27 GMT</pubDate>
    <dc:creator>MK_QSL</dc:creator>
    <dc:date>2015-09-18T15:14:27Z</dc:date>
    <item>
      <title>YTD Issue</title>
      <link>https://community.qlik.com/t5/QlikView/YTD-Issue/m-p/980780#M967859</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Please find attach file my sample date and my output &lt;/P&gt;&lt;P&gt;note that i used these two expressions :&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;1-current =(If(Month_Prod='YTD',RangeSum(Above(Sum({&amp;lt;Year_Prod={"$(=Year(Today()))"}&amp;gt;}Prod_AmountUSD),12-Month(Today())+1,$(vCurrMonth))),Sum({&amp;lt;Year_Prod={"$(=Year(Today()))"}&amp;gt;}Prod_AmountUSD)))/1000000&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;2-Previous=(If(Month_Prod='YTD',RangeSum(Above(Sum({&amp;lt;Year_Prod={"$(=Year(Today())-1)"}&amp;gt;}Prod_AmountUSD),12-Month(Today())+1,$(vCurrMonth))),Sum({&amp;lt;Year_Prod={"$(=Year(Today())-1)"}&amp;gt;}Prod_AmountUSD)))/1000000&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;and Dimenssion as "Month_Prod"&lt;/P&gt;&lt;P&gt;but i am getting wrong YTD Values hope you can help &lt;/P&gt;&lt;P&gt;i need to see the YTD of Previous Year in the same period of current year , if i am in sep-2015 need to see YTD calculated till sep-2014&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 18 Sep 2015 14:48:11 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/YTD-Issue/m-p/980780#M967859</guid>
      <dc:creator>mario-sarkis</dc:creator>
      <dc:date>2015-09-18T14:48:11Z</dc:date>
    </item>
    <item>
      <title>Re: YTD Issue</title>
      <link>https://community.qlik.com/t5/QlikView/YTD-Issue/m-p/980781#M967860</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Check script and Bar Chart expressions from enclosed file..&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 18 Sep 2015 15:14:27 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/YTD-Issue/m-p/980781#M967860</guid>
      <dc:creator>MK_QSL</dc:creator>
      <dc:date>2015-09-18T15:14:27Z</dc:date>
    </item>
    <item>
      <title>Re: YTD Issue</title>
      <link>https://community.qlik.com/t5/QlikView/YTD-Issue/m-p/980782#M967861</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;or 2nd option..&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 18 Sep 2015 15:16:55 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/YTD-Issue/m-p/980782#M967861</guid>
      <dc:creator>MK_QSL</dc:creator>
      <dc:date>2015-09-18T15:16:55Z</dc:date>
    </item>
  </channel>
</rss>

