<?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 Obtain negative values in expression in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Obtain-negative-values-in-expression/m-p/101910#M756647</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P style="font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;Hi.&lt;/P&gt;&lt;P style="font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;I'm trying to get the negative difference of two calculations but I can not with the Aggr.&lt;/P&gt;&lt;P style="font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;&lt;SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;"&gt;- The column displays 2 rows that have negative values.&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;&lt;A href="https://community.qlik.com/legacyfs/online/212849_Captura.PNG" target="_blank"&gt;&lt;IMG __jive_id="212849" alt="Captura.PNG" class="jive-image image-1" height="141" src="https://community.qlik.com/legacyfs/online/212849_Captura.PNG" style="border-width: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;" width="494" /&gt;&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;&lt;SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;"&gt;- What I want to get is the sum of those two negative rows in the other table that only have one dimension&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;&lt;A href="https://community.qlik.com/legacyfs/online/212850_Captura.PNG" target="_blank"&gt;&lt;IMG __jive_id="212850" alt="Captura.PNG" class="jive-image image-2" height="236" src="https://community.qlik.com/legacyfs/online/212850_Captura.PNG" style="border-width: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;" width="506" /&gt;&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;But as it is displayed in the image it shows me the total.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;&lt;A href="https://community.qlik.com/legacyfs/online/212851_Captura.PNG" target="_blank"&gt;&lt;IMG __jive_id="212851" alt="Captura.PNG" class="jive-image image-3" height="236" src="https://community.qlik.com/legacyfs/online/212851_Captura.PNG" style="border-width: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;" width="506" /&gt;&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;I can not find the logic to just add the negative values.&lt;/P&gt;&lt;P style="font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;In this case you should leave -8162.11.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;Please, help me with this problem, I already have time and the desired result does not appear.&lt;/P&gt;&lt;P style="font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;Very thankful.&lt;/P&gt;&lt;P style="font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;Greetings.&lt;/P&gt;&lt;P style="font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;I attach the qvw.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 25 Nov 2020 16:16:04 GMT</pubDate>
    <dc:creator>cristianj23a</dc:creator>
    <dc:date>2020-11-25T16:16:04Z</dc:date>
    <item>
      <title>Obtain negative values in expression</title>
      <link>https://community.qlik.com/t5/QlikView/Obtain-negative-values-in-expression/m-p/101910#M756647</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P style="font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;Hi.&lt;/P&gt;&lt;P style="font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;I'm trying to get the negative difference of two calculations but I can not with the Aggr.&lt;/P&gt;&lt;P style="font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;&lt;SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;"&gt;- The column displays 2 rows that have negative values.&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;&lt;A href="https://community.qlik.com/legacyfs/online/212849_Captura.PNG" target="_blank"&gt;&lt;IMG __jive_id="212849" alt="Captura.PNG" class="jive-image image-1" height="141" src="https://community.qlik.com/legacyfs/online/212849_Captura.PNG" style="border-width: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;" width="494" /&gt;&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;&lt;SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;"&gt;- What I want to get is the sum of those two negative rows in the other table that only have one dimension&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;&lt;A href="https://community.qlik.com/legacyfs/online/212850_Captura.PNG" target="_blank"&gt;&lt;IMG __jive_id="212850" alt="Captura.PNG" class="jive-image image-2" height="236" src="https://community.qlik.com/legacyfs/online/212850_Captura.PNG" style="border-width: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;" width="506" /&gt;&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;But as it is displayed in the image it shows me the total.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;&lt;A href="https://community.qlik.com/legacyfs/online/212851_Captura.PNG" target="_blank"&gt;&lt;IMG __jive_id="212851" alt="Captura.PNG" class="jive-image image-3" height="236" src="https://community.qlik.com/legacyfs/online/212851_Captura.PNG" style="border-width: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;" width="506" /&gt;&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;I can not find the logic to just add the negative values.&lt;/P&gt;&lt;P style="font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;In this case you should leave -8162.11.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;Please, help me with this problem, I already have time and the desired result does not appear.&lt;/P&gt;&lt;P style="font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;Very thankful.&lt;/P&gt;&lt;P style="font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;Greetings.&lt;/P&gt;&lt;P style="font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;I attach the qvw.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 25 Nov 2020 16:16:04 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Obtain-negative-values-in-expression/m-p/101910#M756647</guid>
      <dc:creator>cristianj23a</dc:creator>
      <dc:date>2020-11-25T16:16:04Z</dc:date>
    </item>
    <item>
      <title>Re: Obtain negative values in expression</title>
      <link>https://community.qlik.com/t5/QlikView/Obtain-negative-values-in-expression/m-p/101911#M756648</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Not sure if this solution is acceptable for you.&lt;/P&gt;&lt;P&gt;Maybe someone comes up with a better one.&lt;/P&gt;&lt;P&gt;Have a look if it helps&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 06 Sep 2018 19:09:47 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Obtain-negative-values-in-expression/m-p/101911#M756648</guid>
      <dc:creator>Frank_Hartmann</dc:creator>
      <dc:date>2018-09-06T19:09:47Z</dc:date>
    </item>
  </channel>
</rss>

