topic Re: How to get % for the following in Visualization and Usability https://community.qlik.com/t5/Visualization-and-Usability/How-to-get-for-the-following/m-p/25822#M5295 <HTML><HEAD></HEAD><BODY><P>Try this,</P><P></P><P>Sum (Marks) / Sum(Total&lt;Month&gt; Marks)</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Wed, 31 Jan 2018 06:39:14 GMT kaushiknsolanki 2018-01-31T06:39:14Z How to get % for the following https://community.qlik.com/t5/Visualization-and-Usability/How-to-get-for-the-following/m-p/25821#M5294 <HTML><HEAD></HEAD><BODY><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Subject</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Jan-2017</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Feb-2017</TH></TR><TR><TD style="padding: 2px;">Maths-1</TD><TD style="padding: 2px;">56%</TD><TD style="padding: 2px;">40%</TD></TR><TR><TD style="padding: 2px;">Maths-2</TD><TD style="padding: 2px;">44%</TD><TD style="padding: 2px;">60%</TD></TR></TBODY></TABLE><P></P><P></P><P>Here, I have two subjects maths-1 and maths-2, both for 100 marks each. But I need to a calculation like this, maths1/(maths1+maths2)[Jan-2017], I tried using the following expression. But I show result as 100% both, I want to get sum of maths1 and maths2 to be 100%</P><P></P><P>= Sum(Marks)</P><P>/ ((Sum({&lt;Subject= {'Maths-1}&gt;}</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Marks) </P><P>+ (Sum({&lt;Subject= {'Maths-2'}&gt;}</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Marks) </P></BODY></HTML> Wed, 31 Jan 2018 06:31:20 GMT https://community.qlik.com/t5/Visualization-and-Usability/How-to-get-for-the-following/m-p/25821#M5294 baarathi 2018-01-31T06:31:20Z Re: How to get % for the following https://community.qlik.com/t5/Visualization-and-Usability/How-to-get-for-the-following/m-p/25822#M5295 <HTML><HEAD></HEAD><BODY><P>Try this,</P><P></P><P>Sum (Marks) / Sum(Total&lt;Month&gt; Marks)</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Wed, 31 Jan 2018 06:39:14 GMT https://community.qlik.com/t5/Visualization-and-Usability/How-to-get-for-the-following/m-p/25822#M5295 kaushiknsolanki 2018-01-31T06:39:14Z Re: How to get % for the following https://community.qlik.com/t5/Visualization-and-Usability/How-to-get-for-the-following/m-p/25823#M5296 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Try this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Sum(Marks)/Sum(TOTAL <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Marks)</SPAN></SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Regards</SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">An Pham<BR /></SPAN></P></BODY></HTML> Wed, 31 Jan 2018 06:40:29 GMT https://community.qlik.com/t5/Visualization-and-Usability/How-to-get-for-the-following/m-p/25823#M5296 kenphamvn 2018-01-31T06:40:29Z