<?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 Difference between two rows in Qlik sense in App Development</title>
    <link>https://community.qlik.com/t5/App-Development/Difference-between-two-rows-in-Qlik-sense/m-p/1649556#M48445</link>
    <description>&lt;P&gt;Hi Everyone,&lt;/P&gt;&lt;P&gt;I need to figure out the best logic to calculate the difference between two rows.&lt;/P&gt;&lt;P&gt;for example :-&lt;/P&gt;&lt;TABLE border="1"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD&gt;Week&lt;/TD&gt;&lt;TD&gt;1&lt;/TD&gt;&lt;TD&gt;2&lt;/TD&gt;&lt;TD&gt;3&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;Count of Yes&lt;/TD&gt;&lt;TD&gt;100&lt;/TD&gt;&lt;TD&gt;200&lt;/TD&gt;&lt;TD&gt;250&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;Count of No&lt;/TD&gt;&lt;TD&gt;20&lt;/TD&gt;&lt;TD&gt;50&lt;/TD&gt;&lt;TD&gt;100&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;Week&lt;/TD&gt;&lt;TD&gt;1&lt;/TD&gt;&lt;TD&gt;2&lt;/TD&gt;&lt;TD&gt;3&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;Drop off Yes&amp;nbsp;&lt;/TD&gt;&lt;TD&gt;100&lt;/TD&gt;&lt;TD&gt;50&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;Drop off No&lt;/TD&gt;&lt;TD&gt;30&lt;/TD&gt;&lt;TD&gt;50&lt;/TD&gt;&lt;TD&gt;&lt;P&gt;0&lt;/P&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The values for Count of Yes and Count of No are appeared based on filter selections.&lt;/P&gt;&lt;P&gt;I just need to figure out the logic for calculating&amp;nbsp; Drop off Yes and Drop off No.&lt;/P&gt;&lt;P&gt;Logic for Drop Off Yes = Count of Yes(2) - Count of Yes(1)&amp;nbsp; ie. 200-100=100&lt;/P&gt;&lt;P&gt;Logic for Drop Off No = count of No(2) - Count of No(2) ie. 50-20=30&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Let me know if you have question.&lt;/P&gt;</description>
    <pubDate>Sat, 16 Nov 2024 19:37:27 GMT</pubDate>
    <dc:creator>LP27</dc:creator>
    <dc:date>2024-11-16T19:37:27Z</dc:date>
    <item>
      <title>Difference between two rows in Qlik sense</title>
      <link>https://community.qlik.com/t5/App-Development/Difference-between-two-rows-in-Qlik-sense/m-p/1649556#M48445</link>
      <description>&lt;P&gt;Hi Everyone,&lt;/P&gt;&lt;P&gt;I need to figure out the best logic to calculate the difference between two rows.&lt;/P&gt;&lt;P&gt;for example :-&lt;/P&gt;&lt;TABLE border="1"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD&gt;Week&lt;/TD&gt;&lt;TD&gt;1&lt;/TD&gt;&lt;TD&gt;2&lt;/TD&gt;&lt;TD&gt;3&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;Count of Yes&lt;/TD&gt;&lt;TD&gt;100&lt;/TD&gt;&lt;TD&gt;200&lt;/TD&gt;&lt;TD&gt;250&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;Count of No&lt;/TD&gt;&lt;TD&gt;20&lt;/TD&gt;&lt;TD&gt;50&lt;/TD&gt;&lt;TD&gt;100&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;Week&lt;/TD&gt;&lt;TD&gt;1&lt;/TD&gt;&lt;TD&gt;2&lt;/TD&gt;&lt;TD&gt;3&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;Drop off Yes&amp;nbsp;&lt;/TD&gt;&lt;TD&gt;100&lt;/TD&gt;&lt;TD&gt;50&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;Drop off No&lt;/TD&gt;&lt;TD&gt;30&lt;/TD&gt;&lt;TD&gt;50&lt;/TD&gt;&lt;TD&gt;&lt;P&gt;0&lt;/P&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The values for Count of Yes and Count of No are appeared based on filter selections.&lt;/P&gt;&lt;P&gt;I just need to figure out the logic for calculating&amp;nbsp; Drop off Yes and Drop off No.&lt;/P&gt;&lt;P&gt;Logic for Drop Off Yes = Count of Yes(2) - Count of Yes(1)&amp;nbsp; ie. 200-100=100&lt;/P&gt;&lt;P&gt;Logic for Drop Off No = count of No(2) - Count of No(2) ie. 50-20=30&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Let me know if you have question.&lt;/P&gt;</description>
      <pubDate>Sat, 16 Nov 2024 19:37:27 GMT</pubDate>
      <guid>https://community.qlik.com/t5/App-Development/Difference-between-two-rows-in-Qlik-sense/m-p/1649556#M48445</guid>
      <dc:creator>LP27</dc:creator>
      <dc:date>2024-11-16T19:37:27Z</dc:date>
    </item>
    <item>
      <title>Re: Difference between two rows in Qlik sense</title>
      <link>https://community.qlik.com/t5/App-Development/Difference-between-two-rows-in-Qlik-sense/m-p/1649621#M48454</link>
      <description>&lt;P&gt;Would you be able to share a sample to where we can see what you have?&lt;/P&gt;</description>
      <pubDate>Thu, 21 Nov 2019 13:31:40 GMT</pubDate>
      <guid>https://community.qlik.com/t5/App-Development/Difference-between-two-rows-in-Qlik-sense/m-p/1649621#M48454</guid>
      <dc:creator>sunny_talwar</dc:creator>
      <dc:date>2019-11-21T13:31:40Z</dc:date>
    </item>
    <item>
      <title>Re: Difference between two rows in Qlik sense</title>
      <link>https://community.qlik.com/t5/App-Development/Difference-between-two-rows-in-Qlik-sense/m-p/1649624#M48455</link>
      <description>&lt;P&gt;Sorry Sunny!&amp;nbsp;&lt;/P&gt;&lt;P&gt;At this moment i have got only this scenario.&lt;/P&gt;&lt;P&gt;I am looking to build something with same scenario mentioned, so wanted to get ideas on that.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 21 Nov 2019 13:36:30 GMT</pubDate>
      <guid>https://community.qlik.com/t5/App-Development/Difference-between-two-rows-in-Qlik-sense/m-p/1649624#M48455</guid>
      <dc:creator>LP27</dc:creator>
      <dc:date>2019-11-21T13:36:30Z</dc:date>
    </item>
    <item>
      <title>Re: Difference between two rows in Qlik sense</title>
      <link>https://community.qlik.com/t5/App-Development/Difference-between-two-rows-in-Qlik-sense/m-p/1649675#M48458</link>
      <description>&lt;P&gt;is it possible to be done ?&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 21 Nov 2019 14:25:45 GMT</pubDate>
      <guid>https://community.qlik.com/t5/App-Development/Difference-between-two-rows-in-Qlik-sense/m-p/1649675#M48458</guid>
      <dc:creator>LP27</dc:creator>
      <dc:date>2019-11-21T14:25:45Z</dc:date>
    </item>
  </channel>
</rss>

