topic Re: calculate a ratio in QlikView https://community.qlik.com/t5/QlikView/calculate-a-ratio/m-p/886819#M992212 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #0000ff; font-size: 8pt;">It is better to rename the field Total into myTotal, then:</SPAN></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Group</SPAN><SPAN style="font-size: 8pt;">={'ASF'}&gt;} </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">TOTAL</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">myTotal</SPAN><SPAN style="font-size: 8pt;">)<BR /> /<BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Group</SPAN><SPAN style="font-size: 8pt;">={'RSF'}&gt;} </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">TOTAL</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">myTotal</SPAN><SPAN style="font-size: 8pt;">)<BR /> </SPAN></P></BODY></HTML> Mon, 06 Jul 2015 09:13:38 GMT alexandros17 2015-07-06T09:13:38Z calculate a ratio https://community.qlik.com/t5/QlikView/calculate-a-ratio/m-p/886817#M992210 <HTML><HEAD></HEAD><BODY><P><BR />the data is shown as below:</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 385px;"><TBODY><TR><TD class="xl63" height="17" width="91">Group</TD><TD class="xl64" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="98">COB_Quarter</TD><TD class="xl65" width="98">Total</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="98">NSFR</TD></TR><TR><TD class="xl66" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">ASF</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Q1-2015</TD><TD align="right" class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">285081</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;"> </TD></TR><TR><TD class="xl66" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">ASF</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Q2-2015</TD><TD align="right" class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">270959</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;"> </TD></TR><TR><TD class="xl66" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">ASF</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Q3-2015</TD><TD align="right" class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">138554</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;"> </TD></TR><TR><TD class="xl66" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">RSF</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Q1-2015</TD><TD align="right" class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">124366</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;"> </TD></TR><TR><TD class="xl66" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">RSF</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Q2-2015</TD><TD align="right" class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">234002</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;"> </TD></TR><TR><TD class="xl66" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">RSF</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Q3-2015</TD><TD align="right" class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">316566</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;"> </TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>the result I want is per quarter ASF/RSF in NSFR column</P><P></P><P>Please help me out.</P><P></P><P>Regards</P><P>Srujana</P></BODY></HTML> Mon, 06 Jul 2015 07:14:29 GMT https://community.qlik.com/t5/QlikView/calculate-a-ratio/m-p/886817#M992210 srujanaponnuru 2015-07-06T07:14:29Z Re: calculate a ratio https://community.qlik.com/t5/QlikView/calculate-a-ratio/m-p/886818#M992211 <HTML><HEAD></HEAD><BODY><P>sum({&lt;Group={'ASF'}&gt;}[Total])/<SPAN style="font-size: 13.3333330154419px;">sum({&lt;Group={'RSF'}&gt;}[Total])</SPAN></P></BODY></HTML> Mon, 06 Jul 2015 07:44:18 GMT https://community.qlik.com/t5/QlikView/calculate-a-ratio/m-p/886818#M992211 Gysbert_Wassenaar 2015-07-06T07:44:18Z Re: calculate a ratio https://community.qlik.com/t5/QlikView/calculate-a-ratio/m-p/886819#M992212 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #0000ff; font-size: 8pt;">It is better to rename the field Total into myTotal, then:</SPAN></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Group</SPAN><SPAN style="font-size: 8pt;">={'ASF'}&gt;} </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">TOTAL</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">myTotal</SPAN><SPAN style="font-size: 8pt;">)<BR /> /<BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Group</SPAN><SPAN style="font-size: 8pt;">={'RSF'}&gt;} </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">TOTAL</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">myTotal</SPAN><SPAN style="font-size: 8pt;">)<BR /> </SPAN></P></BODY></HTML> Mon, 06 Jul 2015 09:13:38 GMT https://community.qlik.com/t5/QlikView/calculate-a-ratio/m-p/886819#M992212 alexandros17 2015-07-06T09:13:38Z