<?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 Syntax issue, again, sorry in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Syntax-issue-again-sorry/m-p/483605#M180709</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;BR /&gt;These works:&lt;/P&gt;&lt;P&gt;Sum({$&amp;lt;Labor={'Y'},Entitlement_LaborRate={"&amp;gt;0"}&amp;gt;} Hours)&amp;nbsp; = Entitlement hours&lt;/P&gt;&lt;P&gt;Sum({$&amp;lt;Labor={'Y'}&amp;gt;} Hours) = Total Hours&lt;/P&gt;&lt;P&gt;Sum({$&amp;lt;Labor={'Y'}&amp;gt;} Hours) - Sum({$&amp;lt;Labor={'Y'},Entitlement_LaborRate={"&amp;gt;0"}&amp;gt;} Hours)&amp;nbsp; = Standard hours&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I want the total hours less the entitlement rate hours. . .&amp;nbsp; Basic math works,&lt;/P&gt;&lt;P&gt;set analysis, i can't figure out properly&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;However, the third statement should be able to be written like&lt;/P&gt;&lt;P&gt;Sum({$&amp;lt;Labor={'Y'}&amp;gt;,&amp;lt;Entitlement_LaborRate-={"&amp;gt;0"}&amp;gt;} Hours)&lt;/P&gt;&lt;P&gt;or&lt;/P&gt;&lt;P&gt;Sum({$&amp;lt;Labor={'Y'},Entitlement_LaborRate-={"&amp;gt;0"}&amp;gt;} Hours)&lt;/P&gt;&lt;P&gt;or so one would think . . .&lt;/P&gt;&lt;P&gt;neither of them work correctly&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 26 Sep 2013 16:35:06 GMT</pubDate>
    <dc:creator />
    <dc:date>2013-09-26T16:35:06Z</dc:date>
    <item>
      <title>Syntax issue, again, sorry</title>
      <link>https://community.qlik.com/t5/QlikView/Syntax-issue-again-sorry/m-p/483605#M180709</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;BR /&gt;These works:&lt;/P&gt;&lt;P&gt;Sum({$&amp;lt;Labor={'Y'},Entitlement_LaborRate={"&amp;gt;0"}&amp;gt;} Hours)&amp;nbsp; = Entitlement hours&lt;/P&gt;&lt;P&gt;Sum({$&amp;lt;Labor={'Y'}&amp;gt;} Hours) = Total Hours&lt;/P&gt;&lt;P&gt;Sum({$&amp;lt;Labor={'Y'}&amp;gt;} Hours) - Sum({$&amp;lt;Labor={'Y'},Entitlement_LaborRate={"&amp;gt;0"}&amp;gt;} Hours)&amp;nbsp; = Standard hours&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I want the total hours less the entitlement rate hours. . .&amp;nbsp; Basic math works,&lt;/P&gt;&lt;P&gt;set analysis, i can't figure out properly&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;However, the third statement should be able to be written like&lt;/P&gt;&lt;P&gt;Sum({$&amp;lt;Labor={'Y'}&amp;gt;,&amp;lt;Entitlement_LaborRate-={"&amp;gt;0"}&amp;gt;} Hours)&lt;/P&gt;&lt;P&gt;or&lt;/P&gt;&lt;P&gt;Sum({$&amp;lt;Labor={'Y'},Entitlement_LaborRate-={"&amp;gt;0"}&amp;gt;} Hours)&lt;/P&gt;&lt;P&gt;or so one would think . . .&lt;/P&gt;&lt;P&gt;neither of them work correctly&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 26 Sep 2013 16:35:06 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Syntax-issue-again-sorry/m-p/483605#M180709</guid>
      <dc:creator />
      <dc:date>2013-09-26T16:35:06Z</dc:date>
    </item>
    <item>
      <title>Re: Syntax issue, again, sorry</title>
      <link>https://community.qlik.com/t5/QlikView/Syntax-issue-again-sorry/m-p/483606#M180710</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Maybe this:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Sum({$&amp;lt;Labor={'Y'},Entitlement_LaborRate={"&amp;lt;=0"}&amp;gt;} Hours)&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 26 Sep 2013 17:15:54 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Syntax-issue-again-sorry/m-p/483606#M180710</guid>
      <dc:creator>Carlos_Reyes</dc:creator>
      <dc:date>2013-09-26T17:15:54Z</dc:date>
    </item>
    <item>
      <title>Re: Syntax issue, again, sorry</title>
      <link>https://community.qlik.com/t5/QlikView/Syntax-issue-again-sorry/m-p/483607#M180711</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;A href="https://community.qlik.com/people/carlos.reyes.qv"&gt;carlos.reyes.qv&lt;/A&gt; is right.&lt;/P&gt;&lt;P&gt;&lt;A href="https://community.qlik.com/people/carlos.reyes.qv"&gt;carlos.reyes.qv&lt;/A&gt; está en&amp;nbsp; lo correcto.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Regards.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 26 Sep 2013 19:46:30 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Syntax-issue-again-sorry/m-p/483607#M180711</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2013-09-26T19:46:30Z</dc:date>
    </item>
  </channel>
</rss>

