topic Re: Calculate the composition % by Status in QlikView

topic Re: Calculate the composition % by Status in QlikView https://community.qlik.com/t5/QlikView/Calculate-the-composition-by-Status/m-p/380634#M491418 <HTML><HEAD></HEAD><BODY><P>Thks Felim. It works perfect.</P></BODY></HTML> Mon, 27 Aug 2012 04:12:06 GMT 2012-08-27T04:12:06Z Calculate the composition % by Status https://community.qlik.com/t5/QlikView/Calculate-the-composition-by-Status/m-p/380632#M491416 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P></P><P>Trying to plot a line chart to show the % by status for each month. </P><P>Anyone could help on the expression.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="WIDTH: 228px;"><TBODY><TR><TD height="20" width="64">Mth</TD><TD width="64">Status</TD><TD class="xl64" width="100"> Osbal </TD></TR><TR><TD align="right" class="xl66" height="20">Jul-11</TD><TD class="xl65">NPF</TD><TD class="xl64">       753,570,384 </TD></TR><TR><TD align="right" class="xl66" height="20">Jul-11</TD><TD class="xl65">PF</TD><TD class="xl64">   4,274,057,128 </TD></TR><TR><TD align="right" class="xl66" height="20">Jul-11</TD><TD class="xl65">WL</TD><TD class="xl64">   1,196,916,706 </TD></TR><TR><TD align="right" class="xl66" height="20">Aug-11</TD><TD class="xl65">NPF</TD><TD class="xl64">       755,597,239 </TD></TR><TR><TD align="right" class="xl66" height="20">Aug-11</TD><TD class="xl65">PF</TD><TD class="xl64">   4,468,582,150 </TD></TR><TR><TD align="right" class="xl66" height="20">Aug-11</TD><TD class="xl65">WL</TD><TD class="xl64">   1,157,921,422 </TD></TR></TBODY></TABLE></BODY></HTML> Fri, 24 Aug 2012 09:20:22 GMT https://community.qlik.com/t5/QlikView/Calculate-the-composition-by-Status/m-p/380632#M491416 2012-08-24T09:20:22Z Re: Calculate the composition % by Status https://community.qlik.com/t5/QlikView/Calculate-the-composition-by-Status/m-p/380633#M491417 <HTML><HEAD></HEAD><BODY><P>Are you after something like this</P></BODY></HTML> Fri, 24 Aug 2012 09:26:12 GMT https://community.qlik.com/t5/QlikView/Calculate-the-composition-by-Status/m-p/380633#M491417 2012-08-24T09:26:12Z Re: Calculate the composition % by Status https://community.qlik.com/t5/QlikView/Calculate-the-composition-by-Status/m-p/380634#M491418 <HTML><HEAD></HEAD><BODY><P>Thks Felim. It works perfect.</P></BODY></HTML> Mon, 27 Aug 2012 04:12:06 GMT https://community.qlik.com/t5/QlikView/Calculate-the-composition-by-Status/m-p/380634#M491418 2012-08-27T04:12:06Z