<?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 Slab Wise age calculation in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Slab-Wise-age-calculation/m-p/398883#M148497</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;IMG __jive_id="39680" alt="slb.JPG" class="jive-image-thumbnail jive-image" src="https://community.qlik.com/legacyfs/online/39680_slb.JPG" width="450" /&gt;&lt;/P&gt;&lt;P&gt;I want to calculate above 180 slabs total age value those entres having due date&amp;nbsp; the following expression is used by me&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 8pt;"&gt;&amp;nbsp; &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;=fabs(SUM(AGGR(if(((vDateForAgeing - num(Date(floor([Ledger Due Dt]))) &amp;lt;=180)),&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; SUM([Ledger BalAmt])),[Location Code], [Customer Code])))&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Please help to arrive the same.&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;Vikas &lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 25 Apr 2013 05:42:09 GMT</pubDate>
    <dc:creator>vikasmahajan</dc:creator>
    <dc:date>2013-04-25T05:42:09Z</dc:date>
    <item>
      <title>Slab Wise age calculation</title>
      <link>https://community.qlik.com/t5/QlikView/Slab-Wise-age-calculation/m-p/398883#M148497</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;IMG __jive_id="39680" alt="slb.JPG" class="jive-image-thumbnail jive-image" src="https://community.qlik.com/legacyfs/online/39680_slb.JPG" width="450" /&gt;&lt;/P&gt;&lt;P&gt;I want to calculate above 180 slabs total age value those entres having due date&amp;nbsp; the following expression is used by me&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 8pt;"&gt;&amp;nbsp; &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;=fabs(SUM(AGGR(if(((vDateForAgeing - num(Date(floor([Ledger Due Dt]))) &amp;lt;=180)),&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; SUM([Ledger BalAmt])),[Location Code], [Customer Code])))&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Please help to arrive the same.&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;Vikas &lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 25 Apr 2013 05:42:09 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Slab-Wise-age-calculation/m-p/398883#M148497</guid>
      <dc:creator>vikasmahajan</dc:creator>
      <dc:date>2013-04-25T05:42:09Z</dc:date>
    </item>
  </channel>
</rss>

