topic How to create dimensions based on percentage ? in QlikView https://community.qlik.com/t5/QlikView/How-to-create-dimensions-based-on-percentage/m-p/215803#M69211 <HTML><HEAD></HEAD><BODY><P>If the ranges are the same and in your example that would be the case as each range is 5% then you can use the class function. What information are you dividing up? If the information is fixed it should just be a class(Field,5%,x,0). I'm not sure it is going to take the 5% as a number, but give it a try.</P><P>If the grouping is fixed you can also create these groups in the script. If the grouping is based on a calculation you may have to use an aggr() within the class function. For example, class(aggr(sum(Sales)/sum(total Sales),Customer),5%,x,0).</P><P>If the ranges are of varying lengths (e.g. 0-20%,20-100%) then investigate the valuelist function in the forum.</P><P>Regards.</P></BODY></HTML> Tue, 07 Dec 2010 17:28:42 GMT pover 2010-12-07T17:28:42Z How to create dimensions based on percentage ? https://community.qlik.com/t5/QlikView/How-to-create-dimensions-based-on-percentage/m-p/215802#M69210 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I want to study analytics from websites.</P><P>To do so, I want to slice all my sample in chunk of 5% to have the following thing in X-Avis :</P><P>1. 0-5%</P><P>2. 6-10%</P><P>...</P><P>.95-100%</P><P>How can I create automatically if possible this axis from my data ?</P><P>Can I use the function class() ?</P><P></P><P>Thanks in advance.</P></BODY></HTML> Tue, 07 Dec 2010 17:06:27 GMT https://community.qlik.com/t5/QlikView/How-to-create-dimensions-based-on-percentage/m-p/215802#M69210 2010-12-07T17:06:27Z How to create dimensions based on percentage ? https://community.qlik.com/t5/QlikView/How-to-create-dimensions-based-on-percentage/m-p/215803#M69211 <HTML><HEAD></HEAD><BODY><P>If the ranges are the same and in your example that would be the case as each range is 5% then you can use the class function. What information are you dividing up? If the information is fixed it should just be a class(Field,5%,x,0). I'm not sure it is going to take the 5% as a number, but give it a try.</P><P>If the grouping is fixed you can also create these groups in the script. If the grouping is based on a calculation you may have to use an aggr() within the class function. For example, class(aggr(sum(Sales)/sum(total Sales),Customer),5%,x,0).</P><P>If the ranges are of varying lengths (e.g. 0-20%,20-100%) then investigate the valuelist function in the forum.</P><P>Regards.</P></BODY></HTML> Tue, 07 Dec 2010 17:28:42 GMT https://community.qlik.com/t5/QlikView/How-to-create-dimensions-based-on-percentage/m-p/215803#M69211 pover 2010-12-07T17:28:42Z