topic Re: Selling Rate in QlikView https://community.qlik.com/t5/QlikView/Selling-Rate/m-p/792422#M280136 <HTML><HEAD></HEAD><BODY><P>can you provide sample data/app?</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Wed, 14 Jan 2015 22:11:28 GMT MarcoWedel 2015-01-14T22:11:28Z Selling Rate https://community.qlik.com/t5/QlikView/Selling-Rate/m-p/792417#M280131 <HTML><HEAD></HEAD><BODY><P>Here is another one...</P><P>I have an excel table with 45 items where 28 have the value "sold".</P><P>What I try to do is creating a calculation, Selling Rate in %, that calculates</P><P># of Sold items / # of all items.</P><P>I want to have this displayed next to my chart.</P><P>Can anyone help here?</P><P></P><P>spijatida</P></BODY></HTML> Wed, 14 Jan 2015 19:55:15 GMT https://community.qlik.com/t5/QlikView/Selling-Rate/m-p/792417#M280131 Anonymous 2015-01-14T19:55:15Z Re: Selling Rate https://community.qlik.com/t5/QlikView/Selling-Rate/m-p/792418#M280132 <HTML><HEAD></HEAD><BODY><P>Attached. Let me know if any questions</P></BODY></HTML> Wed, 14 Jan 2015 20:01:47 GMT https://community.qlik.com/t5/QlikView/Selling-Rate/m-p/792418#M280132 reshmakala 2015-01-14T20:01:47Z Re: Selling Rate https://community.qlik.com/t5/QlikView/Selling-Rate/m-p/792419#M280133 <HTML><HEAD></HEAD><BODY><P>Hi there.</P><P></P><P>Use a text box with an expression like:</P><P></P><P>=NUM(COUNT( {$&lt;value={'sold'}&gt;} item) / COUNT(item), , '#.##0,0%')</P><P></P><P>substitute the fields names item and value to match your data.</P><P></P><P>Kind regards,</P><P>Ernesto.</P></BODY></HTML> Wed, 14 Jan 2015 20:04:49 GMT https://community.qlik.com/t5/QlikView/Selling-Rate/m-p/792419#M280133 consenit 2015-01-14T20:04:49Z Re: Selling Rate https://community.qlik.com/t5/QlikView/Selling-Rate/m-p/792420#M280134 <HTML><HEAD></HEAD><BODY><P>Hmm... I get an error in expression</P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">NUM</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">COUNT</SPAN><SPAN style="font-size: 8pt;">( {$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Status</SPAN><SPAN style="font-size: 8pt;">={'Sold'}&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">Status</SPAN><SPAN style="font-size: 8pt;">) / </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">COUNT</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Status</SPAN><SPAN style="font-size: 8pt;">), , '#.##0,0%') </SPAN></P></BODY></HTML> Wed, 14 Jan 2015 21:37:25 GMT https://community.qlik.com/t5/QlikView/Selling-Rate/m-p/792420#M280134 Anonymous 2015-01-14T21:37:25Z Re: Selling Rate https://community.qlik.com/t5/QlikView/Selling-Rate/m-p/792421#M280135 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Remove the second comma before you number format.</P><P></P><P>Regards</P><P>Kamiel</P></BODY></HTML> Wed, 14 Jan 2015 22:10:25 GMT https://community.qlik.com/t5/QlikView/Selling-Rate/m-p/792421#M280135 kamielrajaram 2015-01-14T22:10:25Z Re: Selling Rate https://community.qlik.com/t5/QlikView/Selling-Rate/m-p/792422#M280136 <HTML><HEAD></HEAD><BODY><P>can you provide sample data/app?</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Wed, 14 Jan 2015 22:11:28 GMT https://community.qlik.com/t5/QlikView/Selling-Rate/m-p/792422#M280136 MarcoWedel 2015-01-14T22:11:28Z Re: Selling Rate https://community.qlik.com/t5/QlikView/Selling-Rate/m-p/792423#M280137 <HTML><HEAD></HEAD><BODY><P>duhhh!! Not my day.. thanks Kamiel!!</P></BODY></HTML> Wed, 14 Jan 2015 22:24:16 GMT https://community.qlik.com/t5/QlikView/Selling-Rate/m-p/792423#M280137 Anonymous 2015-01-14T22:24:16Z