topic Re: difference in QlikView https://community.qlik.com/t5/QlikView/difference/m-p/1184432#M882633 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P><STRONG>=If(Aggr(NODISTINCT RowNo(), Col, Col2) &gt; 1, RangeSum(Sum(Col4) - Above(TOTAL Sum(Col4))))</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/138856_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Tue, 27 Sep 2016 16:24:54 GMT sunny_talwar 2016-09-27T16:24:54Z difference https://community.qlik.com/t5/QlikView/difference/m-p/1184429#M882630 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I want build one logic i,e I have a data like below file.</P><P></P><P>Logic is In col2 i have level type ,If i m in A1 level i dont want diff, if i enter into nxt level means A2 iwant to take diff above of record..</P><P></P><P>Output i want is :</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="320"><TBODY><TR><TD height="20" width="64">Col</TD><TD width="64">Col2</TD><TD width="64">Col3</TD><TD width="64">Col4</TD><TD width="64">Output</TD></TR><TR><TD height="20">A</TD><TD>A1</TD><TD align="right">0</TD><TD align="right">0</TD><TD></TD></TR><TR><TD height="20">A</TD><TD>A1</TD><TD align="right">12</TD><TD align="right">32</TD><TD></TD></TR><TR><TD height="20">A</TD><TD>A1</TD><TD align="right">12</TD><TD align="right">35</TD><TD></TD></TR><TR><TD height="20">A</TD><TD>A1</TD><TD align="right">12</TD><TD align="right">2</TD><TD></TD></TR><TR><TD height="20">A</TD><TD>A1</TD><TD align="right">15</TD><TD align="right">37</TD><TD></TD></TR><TR><TD height="20">A</TD><TD>A2</TD><TD align="right">15</TD><TD align="right">39</TD><TD></TD></TR><TR><TD height="20">A</TD><TD>A2</TD><TD align="right">17</TD><TD align="right">41</TD><TD align="right">2</TD></TR><TR><TD height="20">A</TD><TD>A2</TD><TD align="right">18</TD><TD align="right">41</TD><TD align="right">0</TD></TR><TR><TD height="20">A</TD><TD>A2</TD><TD align="right">18</TD><TD align="right">45</TD><TD align="right">4</TD></TR><TR><TD height="20">A</TD><TD>A2</TD><TD align="right">19</TD><TD align="right">45</TD><TD align="right">0</TD></TR><TR><TD height="20">A</TD><TD>A3</TD><TD align="right">20</TD><TD align="right">53</TD><TD align="right">8</TD></TR><TR><TD height="20">A</TD><TD>A3</TD><TD align="right">21</TD><TD align="right">53</TD><TD align="right">0</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/difference/m-p/1184429#M882630 subbareddykm 2020-11-25T16:16:04Z Re: difference https://community.qlik.com/t5/QlikView/difference/m-p/1184430#M882631 <HTML><HEAD></HEAD><BODY><P>How are you getting this 4? Is that correct or typo?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/138844_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 27 Sep 2016 16:15:49 GMT https://community.qlik.com/t5/QlikView/difference/m-p/1184430#M882631 sunny_talwar 2016-09-27T16:15:49Z Re: difference https://community.qlik.com/t5/QlikView/difference/m-p/1184431#M882632 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" width="384"><TBODY><TR><TD height="20" width="64">Col</TD><TD width="64">Col2</TD><TD width="64">Col3</TD><TD width="64">Col4</TD><TD width="64">Output</TD><TD width="64">Logic</TD></TR><TR><TD height="20">A</TD><TD>A1</TD><TD align="right">0</TD><TD align="right">0</TD><TD></TD><TD></TD></TR><TR><TD height="20">A</TD><TD>A1</TD><TD align="right">12</TD><TD align="right">32</TD><TD></TD><TD></TD></TR><TR><TD height="20">A</TD><TD>A1</TD><TD align="right">12</TD><TD align="right">35</TD><TD></TD><TD></TD></TR><TR><TD height="20">A</TD><TD>A1</TD><TD align="right">12</TD><TD align="right">2</TD><TD></TD><TD></TD></TR><TR><TD height="20">A</TD><TD>A1</TD><TD align="right">15</TD><TD align="right">37</TD><TD></TD><TD></TD></TR><TR><TD height="20">A</TD><TD>A2</TD><TD align="right">15</TD><TD align="right">39</TD><TD align="right">2</TD><TD>37-39</TD></TR><TR><TD height="20">A</TD><TD>A2</TD><TD align="right">17</TD><TD align="right">41</TD><TD align="right">2</TD><TD>39-41</TD></TR><TR><TD height="20">A</TD><TD>A2</TD><TD align="right">18</TD><TD align="right">41</TD><TD align="right">0</TD><TD>41-41</TD></TR><TR><TD height="20">A</TD><TD>A2</TD><TD align="right">18</TD><TD align="right">45</TD><TD align="right">4</TD><TD>41-45</TD></TR><TR><TD height="20">A</TD><TD>A2</TD><TD align="right">19</TD><TD align="right">45</TD><TD align="right">0</TD><TD>45-45</TD></TR><TR><TD height="20">A</TD><TD>A3</TD><TD align="right">20</TD><TD align="right">53</TD><TD align="right">8</TD><TD>45-53</TD></TR><TR><TD height="20">A</TD><TD>A3</TD><TD align="right">21</TD><TD align="right">53</TD><TD align="right">0</TD><TD>53-53</TD></TR></TBODY></TABLE></BODY></HTML> Tue, 27 Sep 2016 16:19:43 GMT https://community.qlik.com/t5/QlikView/difference/m-p/1184431#M882632 subbareddykm 2016-09-27T16:19:43Z Re: difference https://community.qlik.com/t5/QlikView/difference/m-p/1184432#M882633 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P><STRONG>=If(Aggr(NODISTINCT RowNo(), Col, Col2) &gt; 1, RangeSum(Sum(Col4) - Above(TOTAL Sum(Col4))))</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/138856_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Tue, 27 Sep 2016 16:24:54 GMT https://community.qlik.com/t5/QlikView/difference/m-p/1184432#M882633 sunny_talwar 2016-09-27T16:24:54Z