topic Help on a set analysis expresion in QlikView https://community.qlik.com/t5/QlikView/Help-on-a-set-analysis-expresion/m-p/226227#M78452 <HTML><HEAD></HEAD><BODY><P>Dear,</P><P>I would like to create a chart (pivot or straight) that shows the following:</P><P>the %age represented by the top 40 customers against the total customers<BR />The number total of their corresponding orders and the %age against the total orders<BR />and the average price of these orders.</P><P>Can any one help me for the expression?</P><P></P><P>with many thanks,</P><P>Guy</P><P><BR /><BR /></P></BODY></HTML> Thu, 21 Apr 2011 14:37:49 GMT guya 2011-04-21T14:37:49Z Help on a set analysis expresion https://community.qlik.com/t5/QlikView/Help-on-a-set-analysis-expresion/m-p/226227#M78452 <HTML><HEAD></HEAD><BODY><P>Dear,</P><P>I would like to create a chart (pivot or straight) that shows the following:</P><P>the %age represented by the top 40 customers against the total customers<BR />The number total of their corresponding orders and the %age against the total orders<BR />and the average price of these orders.</P><P>Can any one help me for the expression?</P><P></P><P>with many thanks,</P><P>Guy</P><P><BR /><BR /></P></BODY></HTML> Thu, 21 Apr 2011 14:37:49 GMT https://community.qlik.com/t5/QlikView/Help-on-a-set-analysis-expresion/m-p/226227#M78452 guya 2011-04-21T14:37:49Z Re. :Help on a set analysis expresion https://community.qlik.com/t5/QlikView/Help-on-a-set-analysis-expresion/m-p/226228#M78453 <HTML><HEAD></HEAD><BODY><P>Hi Guy,</P><P>I think that you must use the Top function in your expression.</P><P>For example :</P><P>sum( Orders) / top( sum( Orders),40)</P><P>Hope this helps <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P><P>Kindly,</P></BODY></HTML> Thu, 21 Apr 2011 15:10:32 GMT https://community.qlik.com/t5/QlikView/Help-on-a-set-analysis-expresion/m-p/226228#M78453 2011-04-21T15:10:32Z