<?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 Expression not working in v9 sr7 and beyond in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Expression-not-working-in-v9-sr7-and-beyond/m-p/322780#M498829</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Has anyone encountered this?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The following expression works in v9 sr6 not in v9 sr7 through v10.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;If (MAX(Year) = Year(Today()),&lt;/P&gt;&lt;P&gt;(sum({$&amp;lt;FlagCurYTD = {1}&amp;gt;}&amp;nbsp; [Sales Amount])&lt;/P&gt;&lt;P&gt;-&lt;/P&gt;&lt;P&gt;sum({$&amp;lt;FlagLastYTD = {1}&amp;gt;}&amp;nbsp; [Sales Amount]))&lt;/P&gt;&lt;P&gt;/&lt;/P&gt;&lt;P&gt;sum({$&amp;lt;FlagLastYTD = {1}&amp;gt;}&amp;nbsp; [Sales Amount]),&lt;/P&gt;&lt;P&gt;(sum({$&amp;lt;Year = {$(=max(Year))}, Period {}&amp;gt;}&amp;nbsp; [Sales Amount])&lt;/P&gt;&lt;P&gt;-&lt;/P&gt;&lt;P&gt;sum({$&amp;lt;Year = {$(=max(Year)-1)}, Period {}&amp;gt;}&amp;nbsp; [Sales Amount]))&lt;/P&gt;&lt;P&gt;/&lt;/P&gt;&lt;P&gt;sum({$&amp;lt;Year = {$(=max(Year)-1)}, Period {}&amp;gt;}&amp;nbsp; [Sales Amount]))&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Mon, 01 Aug 2011 18:09:42 GMT</pubDate>
    <dc:creator />
    <dc:date>2011-08-01T18:09:42Z</dc:date>
    <item>
      <title>Expression not working in v9 sr7 and beyond</title>
      <link>https://community.qlik.com/t5/QlikView/Expression-not-working-in-v9-sr7-and-beyond/m-p/322780#M498829</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Has anyone encountered this?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The following expression works in v9 sr6 not in v9 sr7 through v10.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;If (MAX(Year) = Year(Today()),&lt;/P&gt;&lt;P&gt;(sum({$&amp;lt;FlagCurYTD = {1}&amp;gt;}&amp;nbsp; [Sales Amount])&lt;/P&gt;&lt;P&gt;-&lt;/P&gt;&lt;P&gt;sum({$&amp;lt;FlagLastYTD = {1}&amp;gt;}&amp;nbsp; [Sales Amount]))&lt;/P&gt;&lt;P&gt;/&lt;/P&gt;&lt;P&gt;sum({$&amp;lt;FlagLastYTD = {1}&amp;gt;}&amp;nbsp; [Sales Amount]),&lt;/P&gt;&lt;P&gt;(sum({$&amp;lt;Year = {$(=max(Year))}, Period {}&amp;gt;}&amp;nbsp; [Sales Amount])&lt;/P&gt;&lt;P&gt;-&lt;/P&gt;&lt;P&gt;sum({$&amp;lt;Year = {$(=max(Year)-1)}, Period {}&amp;gt;}&amp;nbsp; [Sales Amount]))&lt;/P&gt;&lt;P&gt;/&lt;/P&gt;&lt;P&gt;sum({$&amp;lt;Year = {$(=max(Year)-1)}, Period {}&amp;gt;}&amp;nbsp; [Sales Amount]))&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 01 Aug 2011 18:09:42 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Expression-not-working-in-v9-sr7-and-beyond/m-p/322780#M498829</guid>
      <dc:creator />
      <dc:date>2011-08-01T18:09:42Z</dc:date>
    </item>
    <item>
      <title>Expression not working in v9 sr7 and beyond</title>
      <link>https://community.qlik.com/t5/QlikView/Expression-not-working-in-v9-sr7-and-beyond/m-p/322781#M498830</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;What's this "Period {}"? shouldn't it be "Period="?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;You should try figuring out what part of the formula isn't working.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 01 Aug 2011 18:42:10 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Expression-not-working-in-v9-sr7-and-beyond/m-p/322781#M498830</guid>
      <dc:creator>danielrozental</dc:creator>
      <dc:date>2011-08-01T18:42:10Z</dc:date>
    </item>
  </channel>
</rss>

