Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to display totals in details

Hi,

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?

4 Replies
ecolomer
Master II
Master II

See this example

Anonymous
Not applicable
Author

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.

Not applicable
Author

Hi Steve,

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.

Not applicable
Author

No,

I only nedd to display the column Califications Summary in the same theme row and when it is expanded, display answers detail.