Qlik Community

Ask a Question

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Aggregation issue

Hello all,

I have a problem with a report I am creating where I need to put all information regarding the people involved in exams, the report should be able to show average score of the person who is being evaluated but also the average of the team this person belong to and also the whole universe within same exams this person has been involved in.

the function I use to get average score is: SUM( RES_VALUE) / (SUM(QST_VALUE) * COUNT(DISTINCT COD_USR))

All your help is very valuable

Thanks

1 Solution

Accepted Solutions
Partner
Partner

Hi Angel,

Here is updated version attached.

Regards!

View solution in original post

7 Replies

Post your document ...

Not applicable

Trying to add the report in new sheet, after will create the report in QV report functionality

Partner
Partner

Hi Angel,

Please review attached. I've created straight table with three expressions for Students, Units and Total.

Hope it will help.

Not applicable

Hi Boris,

Thank you so much for your time,

that's the information I need to show up, but when I select any representative all expressions show me the same thing, so when I select "Adriana Rodriguez" it shows me the same thing in Students, Units and Total.   Is there any way to show Unit and Total information separately when a representative is selected?

thanks in advance

Not applicable

from the Boris expressions, you just need to add a set to ignore FULL_NAME

ex: unit avg:

Avg(Aggr(NODISTINCT

SUM({<FULL_NAME>} RES_VALUE) / (SUM({<FULL_NAME>} QST_VALUE) * COUNT(DISTINCT{<FULL_NAME>}  COD_USR)),

UNIT))

Partner
Partner

Hi Angel,

Here is updated version attached.

Regards!

View solution in original post

Not applicable

Thank you all.

Great.