topic How to display totals in details in Qlik Learning Discussions https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-display-totals-in-details/m-p/766475#M1701 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a table objects with questions answered by somethings groups and I need to display the percent that they got from the pol. the informations like this.</P><P></P><P>Each answer has a value in the pol and I want to acchieve the sumary of all answers and display them on each table row.</P><P></P><P>I want the informations like this:</P><P></P><P><STRONG>Group theme&nbsp;&nbsp; Points&nbsp;&nbsp; Califications&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; %</STRONG></P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 80%</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 85%</P><P></P><P>So it let me to say... ok the group 1 win 18 from 20.</P><P></P><P>See the attatchment with informations below.</P><P></P><P>Anyone can help me?</P></BODY></HTML> Tue, 04 Nov 2014 21:46:26 GMT 2014-11-04T21:46:26Z How to display totals in details https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-display-totals-in-details/m-p/766475#M1701 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a table objects with questions answered by somethings groups and I need to display the percent that they got from the pol. the informations like this.</P><P></P><P>Each answer has a value in the pol and I want to acchieve the sumary of all answers and display them on each table row.</P><P></P><P>I want the informations like this:</P><P></P><P><STRONG>Group theme&nbsp;&nbsp; Points&nbsp;&nbsp; Califications&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; %</STRONG></P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 80%</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 85%</P><P></P><P>So it let me to say... ok the group 1 win 18 from 20.</P><P></P><P>See the attatchment with informations below.</P><P></P><P>Anyone can help me?</P></BODY></HTML> Tue, 04 Nov 2014 21:46:26 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-display-totals-in-details/m-p/766475#M1701 2014-11-04T21:46:26Z Re: How to display totals in details https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-display-totals-in-details/m-p/766476#M1702 <HTML><HEAD></HEAD><BODY><P>See this example</P></BODY></HTML> Tue, 04 Nov 2014 21:50:25 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-display-totals-in-details/m-p/766476#M1702 ecolomer 2014-11-04T21:50:25Z Re: How to display totals in details https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-display-totals-in-details/m-p/766477#M1703 <HTML><HEAD></HEAD><BODY><P>Can't you just create an expression:</P><P></P><P>sum(Calificacion) / sum(Puntos)</P><P></P><P>Then in the number tab set it to display in % and fixed to 0 decimals.</P></BODY></HTML> Tue, 04 Nov 2014 21:51:06 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-display-totals-in-details/m-p/766477#M1703 Anonymous 2014-11-04T21:51:06Z Re: How to display totals in details https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-display-totals-in-details/m-p/766478#M1704 <HTML><HEAD></HEAD><BODY><P>Hi Steve,</P><P></P><P>No&nbsp; I just do it and it didn't work.</P><P>I just type: Sum(Calfications) and it display value 0</P><P>Too Aggr(sum(Calification),Group,Theme) and didn't work.</P><P>Too Sum(Aggr(sum(Calification),Group,Theme)) and didn't work.</P></BODY></HTML> Tue, 04 Nov 2014 21:56:14 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-display-totals-in-details/m-p/766478#M1704 2014-11-04T21:56:14Z Re: How to display totals in details https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-display-totals-in-details/m-p/766479#M1705 <HTML><HEAD></HEAD><BODY><P>No,</P><P></P><P>I only nedd to display the column Califications Summary in the same theme row and when it is expanded, display answers detail.</P></BODY></HTML> Tue, 04 Nov 2014 22:05:38 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-display-totals-in-details/m-p/766479#M1705 2014-11-04T22:05:38Z