topic Re: Sales %age in QlikView https://community.qlik.com/t5/QlikView/Sales-age/m-p/991111#M956249 <HTML><HEAD></HEAD><BODY><P><IMG alt="1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/105343_1.png" style="height: 152px; width: 620px;" /></P></BODY></HTML> Fri, 13 Nov 2015 08:33:19 GMT maxgro 2015-11-13T08:33:19Z Sales %age https://community.qlik.com/t5/QlikView/Sales-age/m-p/991108#M956246 <HTML><HEAD></HEAD><BODY><P>Hello Everyone</P><P>Can you please help me , how to find out Regional Sales %age compare to Total Sales</P><P></P><P>Region&nbsp;&nbsp;&nbsp; Sales&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Regional Sales%age</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Need a fromula here</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; "</SPAN></P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Total&nbsp;&nbsp;&nbsp; 4500 </SPAN></P><P>Sale&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; </SPAN></P><P></P><P>Highly Appreciate for answers</P><P></P><P>Regards</P></BODY></HTML> Fri, 13 Nov 2015 07:44:42 GMT https://community.qlik.com/t5/QlikView/Sales-age/m-p/991108#M956246 2015-11-13T07:44:42Z Re: Sales %age https://community.qlik.com/t5/QlikView/Sales-age/m-p/991109#M956247 <HTML><HEAD></HEAD><BODY><P>Hi Asim, try with:</P><P>Sum(Sales)/Sum(TOTAL Sales)</P><P></P><P>"TOTAL" tells QlikView to consider all the values selected, ignoring table dimensions, so each row divides the value of that region to the sales of all regions.</P><P></P><P>In the 'Numbers' tab of the chart select one of the numeric options (integer, fixed decimal...) and check the option to show in percentage.</P></BODY></HTML> Fri, 13 Nov 2015 08:26:37 GMT https://community.qlik.com/t5/QlikView/Sales-age/m-p/991109#M956247 rubenmarin 2015-11-13T08:26:37Z Re: Sales %age https://community.qlik.com/t5/QlikView/Sales-age/m-p/991110#M956248 <HTML><HEAD></HEAD><BODY><P>Thanks, That worked perfect</P></BODY></HTML> Fri, 13 Nov 2015 08:28:45 GMT https://community.qlik.com/t5/QlikView/Sales-age/m-p/991110#M956248 2015-11-13T08:28:45Z Re: Sales %age https://community.qlik.com/t5/QlikView/Sales-age/m-p/991111#M956249 <HTML><HEAD></HEAD><BODY><P><IMG alt="1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/105343_1.png" style="height: 152px; width: 620px;" /></P></BODY></HTML> Fri, 13 Nov 2015 08:33:19 GMT https://community.qlik.com/t5/QlikView/Sales-age/m-p/991111#M956249 maxgro 2015-11-13T08:33:19Z Re: Sales %age https://community.qlik.com/t5/QlikView/Sales-age/m-p/991112#M956250 <HTML><HEAD></HEAD><BODY><P>please marks Ruben answer correct and close the thread, thanks</P></BODY></HTML> Fri, 13 Nov 2015 08:43:58 GMT https://community.qlik.com/t5/QlikView/Sales-age/m-p/991112#M956250 maxgro 2015-11-13T08:43:58Z