topic Re: Percentage in QlikView https://community.qlik.com/t5/QlikView/Percentage/m-p/429315#M160037 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Try using variable. Assign <STRONG style=": ; color: #ff8000; font-size: 8pt; text-decoration: underline;">SUM(</STRONG><SPAN style="color: #0000ff; font-size: 8pt;">TOTAL</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Comptany 1]</SPAN><SPAN style="font-size: 8pt;">+</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Comptany 2]</SPAN><SPAN style="font-size: 8pt;">+</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Comptany 3]</SPAN><SPAN style="font-size: 8pt;">+</SPAN><SPAN style="color: #800000; font-size: 8pt;">Communs</SPAN><SPAN style="font-size: 8pt;">)&nbsp; </SPAN><SPAN style="font-size: 8pt;">TO some variabe</SPAN></P></BODY></HTML> Fri, 31 May 2013 16:29:43 GMT hirenjadiya 2013-05-31T16:29:43Z Percentage https://community.qlik.com/t5/QlikView/Percentage/m-p/429313#M160035 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have this dynamic table with a percentage (60%) for the sub-total of "Line 1" which I want to apply on the lines where designation='COMMUNS'.</P><P>I have tried many things but couldn't do it.</P><P>Any one has an idea ?</P></BODY></HTML> Fri, 31 May 2013 14:57:57 GMT https://community.qlik.com/t5/QlikView/Percentage/m-p/429313#M160035 Anonymous 2013-05-31T14:57:57Z Re: Percentage https://community.qlik.com/t5/QlikView/Percentage/m-p/429314#M160036 <HTML><HEAD></HEAD><BODY><P>I don't understand your need.</P><P>Could you post an excel with what you want ?</P></BODY></HTML> Fri, 31 May 2013 15:49:48 GMT https://community.qlik.com/t5/QlikView/Percentage/m-p/429314#M160036 2013-05-31T15:49:48Z Re: Percentage https://community.qlik.com/t5/QlikView/Percentage/m-p/429315#M160037 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Try using variable. Assign <STRONG style=": ; color: #ff8000; font-size: 8pt; text-decoration: underline;">SUM(</STRONG><SPAN style="color: #0000ff; font-size: 8pt;">TOTAL</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Comptany 1]</SPAN><SPAN style="font-size: 8pt;">+</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Comptany 2]</SPAN><SPAN style="font-size: 8pt;">+</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Comptany 3]</SPAN><SPAN style="font-size: 8pt;">+</SPAN><SPAN style="color: #800000; font-size: 8pt;">Communs</SPAN><SPAN style="font-size: 8pt;">)&nbsp; </SPAN><SPAN style="font-size: 8pt;">TO some variabe</SPAN></P></BODY></HTML> Fri, 31 May 2013 16:29:43 GMT https://community.qlik.com/t5/QlikView/Percentage/m-p/429315#M160037 hirenjadiya 2013-05-31T16:29:43Z Re: Percentage https://community.qlik.com/t5/QlikView/Percentage/m-p/429316#M160038 <HTML><HEAD></HEAD><BODY><P>See attached example.</P></BODY></HTML> Fri, 31 May 2013 17:55:44 GMT https://community.qlik.com/t5/QlikView/Percentage/m-p/429316#M160038 Gysbert_Wassenaar 2013-05-31T17:55:44Z Re: Percentage https://community.qlik.com/t5/QlikView/Percentage/m-p/429317#M160039 <HTML><HEAD></HEAD><BODY><P>Thanks Gysbert !</P></BODY></HTML> Mon, 03 Jun 2013 17:25:31 GMT https://community.qlik.com/t5/QlikView/Percentage/m-p/429317#M160039 Anonymous 2013-06-03T17:25:31Z