topic Re: How to group this subtotal? in QlikView https://community.qlik.com/t5/QlikView/How-to-group-this-subtotal/m-p/1334097#M411794 <HTML><HEAD></HEAD><BODY><P>Try this</P><P><STRONG>Sum(TOTAL &lt;TERM&gt;DEN)</STRONG></P><P></P><P>or this</P><P><STRONG>Aggr(NODISTINCT Sum(DEN), TERM)</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/169186_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 05 Jul 2017 15:53:39 GMT sunny_talwar 2017-07-05T15:53:39Z How to group this subtotal? https://community.qlik.com/t5/QlikView/How-to-group-this-subtotal/m-p/1334096#M411793 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>For below TermDen field, I want it to be 12 for all three rows in TERM=1, and 18 for three rows of TERM 2. I must aggregated wrong, please advise, the app attached.</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/169197_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /> </P></BODY></HTML> Wed, 05 Jul 2017 15:49:48 GMT https://community.qlik.com/t5/QlikView/How-to-group-this-subtotal/m-p/1334096#M411793 fionna51 2017-07-05T15:49:48Z Re: How to group this subtotal? https://community.qlik.com/t5/QlikView/How-to-group-this-subtotal/m-p/1334097#M411794 <HTML><HEAD></HEAD><BODY><P>Try this</P><P><STRONG>Sum(TOTAL &lt;TERM&gt;DEN)</STRONG></P><P></P><P>or this</P><P><STRONG>Aggr(NODISTINCT Sum(DEN), TERM)</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/169186_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 05 Jul 2017 15:53:39 GMT https://community.qlik.com/t5/QlikView/How-to-group-this-subtotal/m-p/1334097#M411794 sunny_talwar 2017-07-05T15:53:39Z