topic How to calculate a relative % in QlikView https://community.qlik.com/t5/QlikView/How-to-calculate-a-relative/m-p/1076151#M358988 <HTML><HEAD></HEAD><BODY><P>Dear Gurus,</P><P></P><P>Is it any way to calculate the relative % of the total for each line in a straight table?</P><P></P><P>For example:</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Prices&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; % Participation (the one I want to calculate)</P><P><SPAN style="text-decoration: underline;">Average Price&nbsp; </SPAN>&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P>Price 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 80%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>Price 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>Price 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20%</P><P>Price 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100%</P><P></P><P>Thanks!!</P><P></P><P>Regards,</P><P>Jordi</P></BODY></HTML> Tue, 15 Mar 2016 12:22:20 GMT jorditorras 2016-03-15T12:22:20Z How to calculate a relative % https://community.qlik.com/t5/QlikView/How-to-calculate-a-relative/m-p/1076151#M358988 <HTML><HEAD></HEAD><BODY><P>Dear Gurus,</P><P></P><P>Is it any way to calculate the relative % of the total for each line in a straight table?</P><P></P><P>For example:</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Prices&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; % Participation (the one I want to calculate)</P><P><SPAN style="text-decoration: underline;">Average Price&nbsp; </SPAN>&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P>Price 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 80%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>Price 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>Price 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20%</P><P>Price 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100%</P><P></P><P>Thanks!!</P><P></P><P>Regards,</P><P>Jordi</P></BODY></HTML> Tue, 15 Mar 2016 12:22:20 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-a-relative/m-p/1076151#M358988 jorditorras 2016-03-15T12:22:20Z Re: How to calculate a relative % https://community.qlik.com/t5/QlikView/How-to-calculate-a-relative/m-p/1076152#M358989 <HTML><HEAD></HEAD><BODY><P>u can give ur exp&nbsp; </P><P>sum( prices)</P><P></P><P>and go to number tab and chk&nbsp; show in %</P></BODY></HTML> Tue, 15 Mar 2016 12:27:45 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-a-relative/m-p/1076152#M358989 Chanty4u 2016-03-15T12:27:45Z Re: How to calculate a relative % https://community.qlik.com/t5/QlikView/How-to-calculate-a-relative/m-p/1076153#M358990 <HTML><HEAD></HEAD><BODY><P>or else in expression tab&nbsp;&nbsp; u will find relative option u can chk there</P></BODY></HTML> Tue, 15 Mar 2016 12:28:58 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-a-relative/m-p/1076153#M358990 Chanty4u 2016-03-15T12:28:58Z Re: How to calculate a relative % https://community.qlik.com/t5/QlikView/How-to-calculate-a-relative/m-p/1076154#M358991 <HTML><HEAD></HEAD><BODY><P>maybe (you didn´t uploaded your data or expressions)</P><P><STRONG>sum(prices) / sum(total prices)</STRONG></P></BODY></HTML> Tue, 15 Mar 2016 12:36:21 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-a-relative/m-p/1076154#M358991 Clever_Anjos 2016-03-15T12:36:21Z Re: How to calculate a relative % https://community.qlik.com/t5/QlikView/How-to-calculate-a-relative/m-p/1076155#M358992 <HTML><HEAD></HEAD><BODY><P>Check !</P><P></P><P>You can also use expression as </P><P>SUM(Value)/Avg({1}total Value)</P></BODY></HTML> Tue, 15 Mar 2016 12:37:33 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-a-relative/m-p/1076155#M358992 MK_QSL 2016-03-15T12:37:33Z Re: How to calculate a relative % https://community.qlik.com/t5/QlikView/How-to-calculate-a-relative/m-p/1076156#M358993 <HTML><HEAD></HEAD><BODY><P>What expression are you using.</P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Tue, 15 Mar 2016 12:38:32 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-a-relative/m-p/1076156#M358993 its_anandrjs 2016-03-15T12:38:32Z Re: How to calculate a relative % https://community.qlik.com/t5/QlikView/How-to-calculate-a-relative/m-p/1076157#M358994 <HTML><HEAD></HEAD><BODY><P>You are using variable also</P><P></P><P>Ex:-</P><P>Let vAvg = 5</P><P></P><P></P><P>Dim:- Price</P><P></P><P>Expre:- (SUM(Value)/ <STRONG>$(vAvg)</STRONG>)</P><P></P><P><IMG alt="Obj.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/118051_Obj.PNG" style="height: auto;" /></P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Tue, 15 Mar 2016 12:50:25 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-a-relative/m-p/1076157#M358994 its_anandrjs 2016-03-15T12:50:25Z Re: How to calculate a relative % https://community.qlik.com/t5/QlikView/How-to-calculate-a-relative/m-p/1076158#M358995 <HTML><HEAD></HEAD><BODY><P>Thank you! It solved my question!</P><P></P><P>Regards,</P><P>Jordi</P></BODY></HTML> Thu, 17 Mar 2016 09:43:23 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-a-relative/m-p/1076158#M358995 jorditorras 2016-03-17T09:43:23Z