topic Aggregation issue in QlikView

Aggregation issue

Thu, 20 Mar 2014 14:30:06 GMT

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

Re: Aggregation issue

alexandros17 — Thu, 20 Mar 2014 14:32:50 GMT

Post your document ...

Re: Re: Aggregation issue

Thu, 20 Mar 2014 14:59:25 GMT

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

Re: Re: Re: Aggregation issue

bgerchikov — Thu, 20 Mar 2014 18:34:12 GMT

Hi Angel,

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

Hope it will help.

Re: Re: Re: Aggregation issue

Thu, 20 Mar 2014 19:07:59 GMT

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

Re: Aggregation issue

Thu, 20 Mar 2014 19:25:02 GMT

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))

Re: Re: Re: Re: Aggregation issue

bgerchikov — Thu, 20 Mar 2014 20:01:06 GMT

Hi Angel,

Here is updated version attached.

Regards!

Re: Re: Re: Aggregation issue

Thu, 20 Mar 2014 22:20:16 GMT

Thank you all.

Great.