topic Re: Aggregations in QlikView https://community.qlik.com/t5/QlikView/Aggregations/m-p/309281#M497238 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>You tell me ... user 2 average lower than Class average for Haz.11?</P><P>for me is ok, pls to see image attached</P><P>Now respect to your image attached also adjust other image</P><P>Good luck, Luis</P></BODY></HTML> Thu, 06 Oct 2011 19:03:33 GMT llauses243 2011-10-06T19:03:33Z Aggregations https://community.qlik.com/t5/QlikView/Aggregations/m-p/309272#M497229 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I need to have below values on attached sample:</P><P></P><UL><LI>Monthly base average point for each user,</LI><LI>Monthly base average point for each Class group,</LI><LI>Monthly base average point for each Duty group,</LI><LI>Monthly base minimum average point for each Class group</LI><LI>Monthly base maximum average point for each Class group</LI><LI>Monthly base minimum average point for each Duty group</LI><LI>Monthly base maximum average point for each Duty group</LI></UL><P></P><P></P><P>Thanks for your help.</P><P></P><P>Best Regards,</P><P></P><P>Asim Akin </P></BODY></HTML> Tue, 04 Oct 2011 06:14:46 GMT https://community.qlik.com/t5/QlikView/Aggregations/m-p/309272#M497229 2011-10-04T06:14:46Z Re: Aggregations https://community.qlik.com/t5/QlikView/Aggregations/m-p/309273#M497230 <HTML><HEAD></HEAD><BODY><P>see&nbsp; the attached file </P><P>hope thiss helps you</P></BODY></HTML> Tue, 04 Oct 2011 06:49:44 GMT https://community.qlik.com/t5/QlikView/Aggregations/m-p/309273#M497230 SunilChauhan 2011-10-04T06:49:44Z Re: Aggregations https://community.qlik.com/t5/QlikView/Aggregations/m-p/309274#M497231 <HTML><HEAD></HEAD><BODY><P>Hi Sunil,</P><P>I need to show all values in one table. Please check attached file.</P><P>Regards,</P></BODY></HTML> Tue, 04 Oct 2011 07:04:09 GMT https://community.qlik.com/t5/QlikView/Aggregations/m-p/309274#M497231 2011-10-04T07:04:09Z Re: Aggregations https://community.qlik.com/t5/QlikView/Aggregations/m-p/309275#M497232 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P></P><P>see&nbsp; the attached file </P><P>hope this file helps you</P></BODY></HTML> Tue, 04 Oct 2011 07:22:47 GMT https://community.qlik.com/t5/QlikView/Aggregations/m-p/309275#M497232 perumal_41 2011-10-04T07:22:47Z Re: Aggregations https://community.qlik.com/t5/QlikView/Aggregations/m-p/309276#M497233 <HTML><HEAD></HEAD><BODY><P>Thanks Perumal,</P><P>But some of cells have null values. I want to see the values for each line and each cell. Would you please check again.</P><P>Kind Regards,</P></BODY></HTML> Tue, 04 Oct 2011 08:03:32 GMT https://community.qlik.com/t5/QlikView/Aggregations/m-p/309276#M497233 2011-10-04T08:03:32Z Aggregations https://community.qlik.com/t5/QlikView/Aggregations/m-p/309277#M497234 <HTML><HEAD></HEAD><BODY><P>hi, maybe u can use aggr(<SPAN style="text-decoration: underline;"><STRONG>nodistinct</STRONG></SPAN> .....)</P><P></P><P>C u,</P><P>Stefano.</P></BODY></HTML> Tue, 04 Oct 2011 09:15:58 GMT https://community.qlik.com/t5/QlikView/Aggregations/m-p/309277#M497234 2011-10-04T09:15:58Z Re: Aggregations https://community.qlik.com/t5/QlikView/Aggregations/m-p/309278#M497235 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>This is my offer, pls to see image attach</P><P>Good luck, Luis</P></BODY></HTML> Tue, 04 Oct 2011 10:27:33 GMT https://community.qlik.com/t5/QlikView/Aggregations/m-p/309278#M497235 llauses243 2011-10-04T10:27:33Z Re: Aggregations https://community.qlik.com/t5/QlikView/Aggregations/m-p/309279#M497236 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P></P><P>see&nbsp; the attached file </P><P>hope this file helps you</P><P></P><P>Regards,</P><P>Perumal</P></BODY></HTML> Tue, 04 Oct 2011 11:11:39 GMT https://community.qlik.com/t5/QlikView/Aggregations/m-p/309279#M497236 perumal_41 2011-10-04T11:11:39Z Re: Aggregations https://community.qlik.com/t5/QlikView/Aggregations/m-p/309280#M497237 <HTML><HEAD></HEAD><BODY><P>Hi Luis,</P><P>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.</P><P>Would you please check your formulas again?</P><P>Kind Regards,</P></BODY></HTML> Thu, 06 Oct 2011 10:22:30 GMT https://community.qlik.com/t5/QlikView/Aggregations/m-p/309280#M497237 2011-10-06T10:22:30Z Re: Aggregations https://community.qlik.com/t5/QlikView/Aggregations/m-p/309281#M497238 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>You tell me ... user 2 average lower than Class average for Haz.11?</P><P>for me is ok, pls to see image attached</P><P>Now respect to your image attached also adjust other image</P><P>Good luck, Luis</P></BODY></HTML> Thu, 06 Oct 2011 19:03:33 GMT https://community.qlik.com/t5/QlikView/Aggregations/m-p/309281#M497238 llauses243 2011-10-06T19:03:33Z