topic Re: Totals function issue with percentages in App Development https://community.qlik.com/t5/App-Development/Totals-function-issue-with-percentages/m-p/878110#M12147 <HTML><HEAD></HEAD><BODY><P>Thank you for your help!</P></BODY></HTML> Tue, 05 May 2015 20:24:23 GMT undergrinder 2015-05-05T20:24:23Z Totals function issue with percentages https://community.qlik.com/t5/App-Development/Totals-function-issue-with-percentages/m-p/878102#M12139 <HTML><HEAD></HEAD><BODY><P>Hi all!</P><P></P><P>I have a table with </P><UL><LI>1 dimension</LI><LI>2 measure</LI><LI>measure A/measure B in percentages.</LI></UL><P>The table has Total row, and works right with measures, but the percentages columns Total has fake result. (I need the two measure ratio in percentages in the total row, not the sum|min|max|avg of the percentages column). </P><P></P><P>Is there any option to display in total row custom function or other techniques to show the desired result?</P><P></P><P>G.</P></BODY></HTML> Tue, 05 May 2015 12:10:06 GMT https://community.qlik.com/t5/App-Development/Totals-function-issue-with-percentages/m-p/878102#M12139 undergrinder 2015-05-05T12:10:06Z Re: Totals function issue with percentages https://community.qlik.com/t5/App-Development/Totals-function-issue-with-percentages/m-p/878103#M12140 <HTML><HEAD></HEAD><BODY><P>There definitely is a way to achieve what you want, but you will need to provide a sample as well as the logic for your expect result.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Tue, 05 May 2015 12:16:43 GMT https://community.qlik.com/t5/App-Development/Totals-function-issue-with-percentages/m-p/878103#M12140 sunny_talwar 2015-05-05T12:16:43Z Re: Totals function issue with percentages https://community.qlik.com/t5/App-Development/Totals-function-issue-with-percentages/m-p/878104#M12141 <HTML><HEAD></HEAD><BODY><P>Thank you for the comment!</P><P></P><P>Here is an example:</P><P><IMG alt="Névtelen.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/85718_Névtelen.png" style="height: auto;" /></P><P>The Total row is for the sum of facts and plans, but at the ratio this approach is false.</P><P></P><P><STRONG>UPDATE:</STRONG> If I change the Total function to None, i get the desired result, but i do not know why.</P><P></P><P>G.</P></BODY></HTML> Tue, 05 May 2015 19:18:32 GMT https://community.qlik.com/t5/App-Development/Totals-function-issue-with-percentages/m-p/878104#M12141 undergrinder 2015-05-05T19:18:32Z Re: Totals function issue with percentages https://community.qlik.com/t5/App-Development/Totals-function-issue-with-percentages/m-p/878105#M12142 <HTML><HEAD></HEAD><BODY><P>So ideally you would want to see <STRONG>9/83 = 10.84% </STRONG>as the total?</P></BODY></HTML> Tue, 05 May 2015 19:20:57 GMT https://community.qlik.com/t5/App-Development/Totals-function-issue-with-percentages/m-p/878105#M12142 sunny_talwar 2015-05-05T19:20:57Z Re: Totals function issue with percentages https://community.qlik.com/t5/App-Development/Totals-function-issue-with-percentages/m-p/878106#M12143 <HTML><HEAD></HEAD><BODY><P>Yes, exactly</P></BODY></HTML> Tue, 05 May 2015 19:21:57 GMT https://community.qlik.com/t5/App-Development/Totals-function-issue-with-percentages/m-p/878106#M12143 undergrinder 2015-05-05T19:21:57Z Re: Totals function issue with percentages https://community.qlik.com/t5/App-Development/Totals-function-issue-with-percentages/m-p/878107#M12144 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>Sum(Aggr(Sum(FACT), DIM))/</STRONG><SPAN style="font-size: 13.3333330154419px;"><STRONG>Sum(Aggr(Sum(PLAN), DIM))</STRONG></SPAN></P></BODY></HTML> Tue, 05 May 2015 19:24:20 GMT https://community.qlik.com/t5/App-Development/Totals-function-issue-with-percentages/m-p/878107#M12144 sunny_talwar 2015-05-05T19:24:20Z Re: Totals function issue with percentages https://community.qlik.com/t5/App-Development/Totals-function-issue-with-percentages/m-p/878108#M12145 <HTML><HEAD></HEAD><BODY><P>Thank you,</P><P>the formula give the same result as sum(Fact)/sum(Plan), the problem was in the Total row.</P><P></P><P><IMG alt="Névtelen.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/85723_Névtelen.png" style="height: auto;" /></P><P>The solution is change the Total function to None, but i do not understand why.</P><P></P><P>G.</P></BODY></HTML> Tue, 05 May 2015 19:55:05 GMT https://community.qlik.com/t5/App-Development/Totals-function-issue-with-percentages/m-p/878108#M12145 undergrinder 2015-05-05T19:55:05Z Re: Totals function issue with percentages https://community.qlik.com/t5/App-Development/Totals-function-issue-with-percentages/m-p/878109#M12146 <HTML><HEAD></HEAD><BODY><P>Oh so you got it to work? Great. I am not very familiar with Qlik Sense, but I used my QlikView expertise to try and help you out.</P><P></P><P>I am glad you have your solution and I would suggest marking your answer as correct so that the thread is closed and can be used by others in the future <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Tue, 05 May 2015 20:00:35 GMT https://community.qlik.com/t5/App-Development/Totals-function-issue-with-percentages/m-p/878109#M12146 sunny_talwar 2015-05-05T20:00:35Z Re: Totals function issue with percentages https://community.qlik.com/t5/App-Development/Totals-function-issue-with-percentages/m-p/878110#M12147 <HTML><HEAD></HEAD><BODY><P>Thank you for your help!</P></BODY></HTML> Tue, 05 May 2015 20:24:23 GMT https://community.qlik.com/t5/App-Development/Totals-function-issue-with-percentages/m-p/878110#M12147 undergrinder 2015-05-05T20:24:23Z Re: Totals function issue with percentages https://community.qlik.com/t5/App-Development/Totals-function-issue-with-percentages/m-p/878111#M12148 <HTML><HEAD></HEAD><BODY><P>No problem <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 05 May 2015 20:25:26 GMT https://community.qlik.com/t5/App-Development/Totals-function-issue-with-percentages/m-p/878111#M12148 sunny_talwar 2015-05-05T20:25:26Z