Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Aggregations

Dear All,

I need to have below values on attached sample:

  • Monthly base average point for each user,
  • Monthly base average point for each Class group,
  • Monthly base average point for each Duty group,
  • Monthly base minimum average point for each Class group
  • Monthly base maximum average point for each Class group
  • Monthly base minimum average point for each Duty group
  • Monthly base maximum average point for each Duty group

Thanks for your help.

Best Regards,

Asim Akin

Tags (2)
1 Solution

Accepted Solutions
llauses243
Contributor III

Re: Aggregations

Hi,

You tell me ... user 2 average lower than Class average for Haz.11?

for me is ok, pls to see image attached

Now respect to your image attached also adjust other image

Good luck, Luis

View solution in original post

9 Replies
SunilChauhan
Esteemed Contributor

Re: Aggregations

see  the attached file

hope thiss helps you

Not applicable

Re: Aggregations

Hi Sunil,

I need to show all values in one table. Please check attached file.

Regards,

Partner
Partner

Re: Aggregations

Hi,

see  the attached file

hope this file helps you

Not applicable

Re: Aggregations

Thanks Perumal,

But some of cells have null values. I want to see the values for each line and each cell. Would you please check again.

Kind Regards,

Not applicable

Aggregations

hi, maybe u can use aggr(nodistinct .....)

C u,

Stefano.

llauses243
Contributor III

Re: Aggregations

Hi,

This is my offer, pls to see image attach

Good luck, Luis

Partner
Partner

Re: Aggregations

Hi,

see  the attached file

hope this file helps you

Regards,

Perumal

Not applicable

Re: Aggregations

Hi Luis,

I don't understand how can be the user 2 average lower than Class average for Haz.11? Would you please check attached image. The average of a person cannot be lower than class or duty minimum average. It may be equal but cannot be lower.

Would you please check your formulas again?

Kind Regards,

llauses243
Contributor III

Re: Aggregations

Hi,

You tell me ... user 2 average lower than Class average for Haz.11?

for me is ok, pls to see image attached

Now respect to your image attached also adjust other image

Good luck, Luis

View solution in original post