topic Re: Problem with aggr command in QlikView https://community.qlik.com/t5/QlikView/Problem-with-aggr-command/m-p/881104#M307455 <HTML><HEAD></HEAD><BODY><P>It is correct.</P><P></P><P>Thank you very much.</P></BODY></HTML> Fri, 12 Jun 2015 10:16:54 GMT geogou1973 2015-06-12T10:16:54Z Problem with aggr command https://community.qlik.com/t5/QlikView/Problem-with-aggr-command/m-p/881102#M307453 <HTML><HEAD></HEAD><BODY><P>Hello.</P><P></P><P>I am facing a problem with the aggr command.</P><P>I attach a qvw that i have some data and in the level of item the aggregation is correct about the summary of maximum QTY,</P><P>but when i create a chart in the level of promo code i miss in the promo 517085 the QTY 2 that summarized in the other promos.</P><P>When i select only the promo code 517085 the result is correct QTY 2</P><P></P><P>Can anyone help me to find a solution ?</P><P></P><P>Thank you in advance.</P></BODY></HTML> Fri, 12 Jun 2015 09:43:36 GMT https://community.qlik.com/t5/QlikView/Problem-with-aggr-command/m-p/881102#M307453 geogou1973 2015-06-12T09:43:36Z Re: Problem with aggr command https://community.qlik.com/t5/QlikView/Problem-with-aggr-command/m-p/881103#M307454 <HTML><HEAD></HEAD><BODY><P>Not really sure what you want to calculate, but maybe you need the NODISTINCT qualifier here:</P><P>=SUM(aggr(NODISTINCT max(QTY),SALE_NBR,SALE_LINE))</P></BODY></HTML> Fri, 12 Jun 2015 09:49:02 GMT https://community.qlik.com/t5/QlikView/Problem-with-aggr-command/m-p/881103#M307454 swuehl 2015-06-12T09:49:02Z Re: Problem with aggr command https://community.qlik.com/t5/QlikView/Problem-with-aggr-command/m-p/881104#M307455 <HTML><HEAD></HEAD><BODY><P>It is correct.</P><P></P><P>Thank you very much.</P></BODY></HTML> Fri, 12 Jun 2015 10:16:54 GMT https://community.qlik.com/t5/QlikView/Problem-with-aggr-command/m-p/881104#M307455 geogou1973 2015-06-12T10:16:54Z