topic Re: How to calculate the conversion %? in QlikView https://community.qlik.com/t5/QlikView/How-to-calculate-the-conversion/m-p/633406#M1087027 <HTML><HEAD></HEAD><BODY><P>Thanks.</P></BODY></HTML> Fri, 30 May 2014 08:40:38 GMT 2014-05-30T08:40:38Z How to calculate the conversion %? https://community.qlik.com/t5/QlikView/How-to-calculate-the-conversion/m-p/633404#M1087025 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>I have one excel file with data which I need to build a straight table.</P><P></P><P>The excel have data</P><P></P><P>Noof students applied = 220</P><P>Noof students got admission = 156</P><P></P><P>How can I calculate the conversion rate %? could anyone suggest me please.</P><P></P><P>Thanks.</P></BODY></HTML> Fri, 30 May 2014 07:51:00 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-the-conversion/m-p/633404#M1087025 2014-05-30T07:51:00Z Re: How to calculate the conversion %? https://community.qlik.com/t5/QlikView/How-to-calculate-the-conversion/m-p/633405#M1087026 <HTML><HEAD></HEAD><BODY><P>Any formula for that or may be</P><P></P><P>=Count(Student got admission) / <SPAN style="font-size: 10pt; line-height: 1.5em;">Count(Student Applied)</SPAN></P><P></P><P>and change the format into %</P></BODY></HTML> Fri, 30 May 2014 07:54:52 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-the-conversion/m-p/633405#M1087026 its_anandrjs 2014-05-30T07:54:52Z Re: How to calculate the conversion %? https://community.qlik.com/t5/QlikView/How-to-calculate-the-conversion/m-p/633406#M1087027 <HTML><HEAD></HEAD><BODY><P>Thanks.</P></BODY></HTML> Fri, 30 May 2014 08:40:38 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-the-conversion/m-p/633406#M1087027 2014-05-30T08:40:38Z