Discussion Board for collaboration related to Qlik Education.
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.
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.
I want the informations like this:
Group theme Points Califications %
1 1 20 18 80%
1 2 14 14 100%
2 1 18 14 85%
So it let me to say... ok the group 1 win 18 from 20.
See the attatchment with informations below.
Anyone can help me?
See this example
Can't you just create an expression:
sum(Calificacion) / sum(Puntos)
Then in the number tab set it to display in % and fixed to 0 decimals.
No I just do it and it didn't work.
I just type: Sum(Calfications) and it display value 0
Too Aggr(sum(Calification),Group,Theme) and didn't work.
Too Sum(Aggr(sum(Calification),Group,Theme)) and didn't work.
I only nedd to display the column Califications Summary in the same theme row and when it is expanded, display answers detail.