Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

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
Honored Contributor II

Re: How to display totals in details

See this example

stevenrtaylor
Contributor II

Re: How to display totals in details

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

Re: How to display totals in details

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

Re: How to display totals in details

No,

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

Community Browser