topic Re: Calculating Percentage in QlikView https://community.qlik.com/t5/QlikView/Calculating-Percentage/m-p/701485#M253215 <HTML><HEAD></HEAD><BODY><P>Sum({&lt;Field_X={1}&gt;} Field_X) /Sum(Field_X) *100</P><P></P><P>Update: You might want to&nbsp; replace latter Sum() with Count()</P></BODY></HTML> Tue, 19 Aug 2014 07:33:47 GMT tresB 2014-08-19T07:33:47Z Calculating Percentage https://community.qlik.com/t5/QlikView/Calculating-Percentage/m-p/701483#M253213 <HTML><HEAD></HEAD><BODY><P>I have one field. Let's name it 'Field_X'.<BR />Field values are either 0 or 1.</P><P></P><P>I have to make the following calculation:</P><P>- for a secain selection i need a sum of all rows that contan Field_X = 1, divided by all rows (Field_X = 0 or 1). <BR />Then I need to multiply it by 100 to get the percent.</P><P></P><P>How can I do it? With IF statement? CASE statement?</P></BODY></HTML> Tue, 19 Aug 2014 07:28:45 GMT https://community.qlik.com/t5/QlikView/Calculating-Percentage/m-p/701483#M253213 2014-08-19T07:28:45Z Re: Calculating Percentage https://community.qlik.com/t5/QlikView/Calculating-Percentage/m-p/701484#M253214 <HTML><HEAD></HEAD><BODY><P>Maybe:</P><P>= (</P><P>&nbsp; SUM(Field_x)<BR />/</P><P>COUNT(Field_x)</P><P>) * 100</P><P></P><P>Problem is I always get for SUM(Field_x) value 1...</P></BODY></HTML> Tue, 19 Aug 2014 07:31:36 GMT https://community.qlik.com/t5/QlikView/Calculating-Percentage/m-p/701484#M253214 2014-08-19T07:31:36Z Re: Calculating Percentage https://community.qlik.com/t5/QlikView/Calculating-Percentage/m-p/701485#M253215 <HTML><HEAD></HEAD><BODY><P>Sum({&lt;Field_X={1}&gt;} Field_X) /Sum(Field_X) *100</P><P></P><P>Update: You might want to&nbsp; replace latter Sum() with Count()</P></BODY></HTML> Tue, 19 Aug 2014 07:33:47 GMT https://community.qlik.com/t5/QlikView/Calculating-Percentage/m-p/701485#M253215 tresB 2014-08-19T07:33:47Z Re: Re: Calculating Percentage https://community.qlik.com/t5/QlikView/Calculating-Percentage/m-p/701486#M253216 <HTML><HEAD></HEAD><BODY><P>I have tried with your expression and its working fine.</P></BODY></HTML> Tue, 19 Aug 2014 07:40:15 GMT https://community.qlik.com/t5/QlikView/Calculating-Percentage/m-p/701486#M253216 senpradip007 2014-08-19T07:40:15Z