Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
llauses243
Creator III
Creator III

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
TigerisBack
Champion
Champion

see  the attached file

hope thiss helps you

Not applicable
Author

Hi Sunil,

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

Regards,

perumal_41
Partner
Partner

Hi,

see  the attached file

hope this file helps you

Not applicable
Author

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
Author

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

C u,

Stefano.

llauses243
Creator III
Creator III

Hi,

This is my offer, pls to see image attach

Good luck, Luis

perumal_41
Partner
Partner

Hi,

see  the attached file

hope this file helps you

Regards,

Perumal

Not applicable
Author

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
Creator III
Creator III

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