topic Re: Table expression using Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Table-expression-using-Set-Analysis/m-p/630930#M1087417 <HTML><HEAD></HEAD><BODY><P>As per my understanding you are calculating proportion.</P><P></P><P>try with: Sum(Sales) / Sum(TOTAL Sales).</P></BODY></HTML> Wed, 28 May 2014 11:36:34 GMT senpradip007 2014-05-28T11:36:34Z Table expression using Set Analysis https://community.qlik.com/t5/QlikView/Table-expression-using-Set-Analysis/m-p/630928#M1087415 <HTML><HEAD></HEAD><BODY><P>Hey all, </P><P></P><P>I need help in writing the table expression.</P><P>Lets say, I have different products and my first expression is sum(sales).</P><P>I need second expression that will calculate sum(sales) out of TOTAL sum(sales) and show the result in percents...</P></BODY></HTML> Wed, 28 May 2014 11:32:49 GMT https://community.qlik.com/t5/QlikView/Table-expression-using-Set-Analysis/m-p/630928#M1087415 linoyel 2014-05-28T11:32:49Z Re: Table expression using Set Analysis https://community.qlik.com/t5/QlikView/Table-expression-using-Set-Analysis/m-p/630929#M1087416 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P>=Sum(Sales)/Sum(TOTAL Sales)</P><P>And check/tick 'Show in percent (%)' in the number tab.</P></BODY></HTML> Wed, 28 May 2014 11:35:57 GMT https://community.qlik.com/t5/QlikView/Table-expression-using-Set-Analysis/m-p/630929#M1087416 tresB 2014-05-28T11:35:57Z Re: Table expression using Set Analysis https://community.qlik.com/t5/QlikView/Table-expression-using-Set-Analysis/m-p/630930#M1087417 <HTML><HEAD></HEAD><BODY><P>As per my understanding you are calculating proportion.</P><P></P><P>try with: Sum(Sales) / Sum(TOTAL Sales).</P></BODY></HTML> Wed, 28 May 2014 11:36:34 GMT https://community.qlik.com/t5/QlikView/Table-expression-using-Set-Analysis/m-p/630930#M1087417 senpradip007 2014-05-28T11:36:34Z Re: Table expression using Set Analysis https://community.qlik.com/t5/QlikView/Table-expression-using-Set-Analysis/m-p/630931#M1087418 <HTML><HEAD></HEAD><BODY><P>Than't right!!!</P><P>Thank you so much <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 28 May 2014 11:56:26 GMT https://community.qlik.com/t5/QlikView/Table-expression-using-Set-Analysis/m-p/630931#M1087418 linoyel 2014-05-28T11:56:26Z Re: Table expression using Set Analysis https://community.qlik.com/t5/QlikView/Table-expression-using-Set-Analysis/m-p/630932#M1087419 <HTML><HEAD></HEAD><BODY><P>Thank You for you help..</P></BODY></HTML> Wed, 28 May 2014 13:18:33 GMT https://community.qlik.com/t5/QlikView/Table-expression-using-Set-Analysis/m-p/630932#M1087419 2014-05-28T13:18:33Z