topic Re: Calculate Top 40% in QlikView https://community.qlik.com/t5/QlikView/Calculate-Top-40/m-p/1263957#M856963 <HTML><HEAD></HEAD><BODY><P>Hi Satya,</P><P></P><P>Please elaborate your issue.</P><P>On which basis percentage is calculated.</P><P>i couldn't able to understand "<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Count for Top 40 % by tons </STRONG></SPAN><STRONG>"</STRONG></P><P>you need which count?</P></BODY></HTML> Wed, 01 Feb 2017 13:29:43 GMT omkarvamsi 2017-02-01T13:29:43Z Calculate Top 40% https://community.qlik.com/t5/QlikView/Calculate-Top-40/m-p/1263956#M856962 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I want to calculate the Count for Top 40 % by tons using set analysis for Material Type (ABC) .I have attached excel file.</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/151399_Capture.PNG" style="height: 349px; width: 620px;" /></P><P></P><P>Thanks in advance.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Calculate-Top-40/m-p/1263956#M856962 Anonymous 2020-11-25T16:16:04Z Re: Calculate Top 40% https://community.qlik.com/t5/QlikView/Calculate-Top-40/m-p/1263957#M856963 <HTML><HEAD></HEAD><BODY><P>Hi Satya,</P><P></P><P>Please elaborate your issue.</P><P>On which basis percentage is calculated.</P><P>i couldn't able to understand "<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Count for Top 40 % by tons </STRONG></SPAN><STRONG>"</STRONG></P><P>you need which count?</P></BODY></HTML> Wed, 01 Feb 2017 13:29:43 GMT https://community.qlik.com/t5/QlikView/Calculate-Top-40/m-p/1263957#M856963 omkarvamsi 2017-02-01T13:29:43Z Re: Calculate Top 40% https://community.qlik.com/t5/QlikView/Calculate-Top-40/m-p/1263958#M856964 <HTML><HEAD></HEAD><BODY><P>Do you mean &lt; 40%</P><P></P><P><STRONG>Sum({&lt;<SPAN style="font-size: 13.3333px;">Value(Count of Tons)</SPAN> = {'&lt;= 40.00 %'}&gt;} Tons)</STRONG></P></BODY></HTML> Wed, 01 Feb 2017 13:39:53 GMT https://community.qlik.com/t5/QlikView/Calculate-Top-40/m-p/1263958#M856964 Anil_Babu_Samineni 2017-02-01T13:39:53Z