topic Re: How do I work out percentage in expression in QlikView https://community.qlik.com/t5/QlikView/How-do-I-work-out-percentage-in-expression/m-p/459816#M1166107 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Try like this</P><P></P><P>count(<SPAN style="font-size: 19px; color: #0000ff;">if</SPAN>(<SPAN style="font-size: 19px; color: #0000ff;">len</SPAN>(<SPAN style="font-size: 19px; color: #800000;">[Default Notice Date]</SPAN>&gt;'0'),<SPAN style="font-size: 19px; color: #800000;">BP)</SPAN>)/<SPAN style="font-size: 19px; color: #0000ff;">count</SPAN>(total <SPAN style="font-size: 19px; color: #0000ff;">if</SPAN>(<SPAN style="font-size: 19px; color: #0000ff;">len</SPAN>(<SPAN style="font-size: 19px; color: #800000;">[Registration Date]</SPAN>&gt;'0'), <SPAN style="font-size: 19px; color: #800000;">BP</SPAN>))</P><P></P><P>hope it helps</P></BODY></HTML> Tue, 02 Oct 2012 12:52:08 GMT MayilVahanan 2012-10-02T12:52:08Z How do I work out percentage in expression https://community.qlik.com/t5/QlikView/How-do-I-work-out-percentage-in-expression/m-p/459815#M1166106 <HTML><HEAD></HEAD><BODY><P>Hi, I need to work out a % of a number in an expression and this just isnt working :-</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"></SPAN></P><P><SPAN style="font-size: 14pt;">count(<SPAN style="color: #0000ff;">if</SPAN>(<SPAN style="color: #0000ff;">len</SPAN>(<SPAN style="color: #800000;">[Default Notice Date]</SPAN>&gt;'0'),<SPAN style="color: #800000;">BP</SPAN>)/<SPAN style="color: #0000ff;">count</SPAN>(<SPAN style="color: #0000ff;">if</SPAN>(<SPAN style="color: #0000ff;">len</SPAN>(<SPAN style="color: #800000;">[Registration Date]</SPAN>&gt;'0'),<SPAN style="color: #800000;">BP</SPAN>)*100)) </SPAN></P><P></P></BODY></HTML> Tue, 02 Oct 2012 12:45:15 GMT https://community.qlik.com/t5/QlikView/How-do-I-work-out-percentage-in-expression/m-p/459815#M1166106 2012-10-02T12:45:15Z Re: How do I work out percentage in expression https://community.qlik.com/t5/QlikView/How-do-I-work-out-percentage-in-expression/m-p/459816#M1166107 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Try like this</P><P></P><P>count(<SPAN style="font-size: 19px; color: #0000ff;">if</SPAN>(<SPAN style="font-size: 19px; color: #0000ff;">len</SPAN>(<SPAN style="font-size: 19px; color: #800000;">[Default Notice Date]</SPAN>&gt;'0'),<SPAN style="font-size: 19px; color: #800000;">BP)</SPAN>)/<SPAN style="font-size: 19px; color: #0000ff;">count</SPAN>(total <SPAN style="font-size: 19px; color: #0000ff;">if</SPAN>(<SPAN style="font-size: 19px; color: #0000ff;">len</SPAN>(<SPAN style="font-size: 19px; color: #800000;">[Registration Date]</SPAN>&gt;'0'), <SPAN style="font-size: 19px; color: #800000;">BP</SPAN>))</P><P></P><P>hope it helps</P></BODY></HTML> Tue, 02 Oct 2012 12:52:08 GMT https://community.qlik.com/t5/QlikView/How-do-I-work-out-percentage-in-expression/m-p/459816#M1166107 MayilVahanan 2012-10-02T12:52:08Z