topic Re: Problems with AGGR function in QlikView https://community.qlik.com/t5/QlikView/Problems-with-AGGR-function/m-p/824641#M473019 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try below expression</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><P>Sum </P><P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">LiefDatum</SPAN><SPAN style="font-size: 8pt;">), </SPAN><SPAN style="color: #800000; font-size: 8pt;">ShipID</SPAN><SPAN style="font-size: 8pt;">, </SPAN><SPAN style="color: #800000; font-size: 8pt;">AdrEmpf</SPAN><SPAN style="font-size: 8pt;">))<BR /></SPAN></P></BODY></HTML> Wed, 26 Nov 2014 12:41:00 GMT perumal_41 2014-11-26T12:41:00Z Problems with AGGR function https://community.qlik.com/t5/QlikView/Problems-with-AGGR-function/m-p/824638#M473016 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P></P><P>I have to calculate the number of shipments aggregated by Adress and Shipping ID</P><P>The correct outcome should be 87. (in Excel)</P><P></P><P>I used this formula: =Aggr(count(LiefDatum), ShipID, AdrEmpf)</P><P></P><P>My result in QV is 1 <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P><P></P><P>What's wrong? Would be nice if somebody could give me a tipp</P><P></P><P>Oliver</P></BODY></HTML> Wed, 26 Nov 2014 12:35:26 GMT https://community.qlik.com/t5/QlikView/Problems-with-AGGR-function/m-p/824638#M473016 2014-11-26T12:35:26Z Re: Problems with AGGR function https://community.qlik.com/t5/QlikView/Problems-with-AGGR-function/m-p/824639#M473017 <HTML><HEAD></HEAD><BODY><P>Hi Oliver,</P><P></P><P>Please post some sample data.</P></BODY></HTML> Wed, 26 Nov 2014 12:39:31 GMT https://community.qlik.com/t5/QlikView/Problems-with-AGGR-function/m-p/824639#M473017 ashwanin 2014-11-26T12:39:31Z Re: Problems with AGGR function https://community.qlik.com/t5/QlikView/Problems-with-AGGR-function/m-p/824640#M473018 <HTML><HEAD></HEAD><BODY><P>Hi Oliver,</P><P>almost correct, you only need to sum the different results of the aggr function:</P><P>=Sum(Aggr(count(LiefDatum), ShipID, AdrEmpf))</P></BODY></HTML> Wed, 26 Nov 2014 12:40:54 GMT https://community.qlik.com/t5/QlikView/Problems-with-AGGR-function/m-p/824640#M473018 rubenmarin 2014-11-26T12:40:54Z Re: Problems with AGGR function https://community.qlik.com/t5/QlikView/Problems-with-AGGR-function/m-p/824641#M473019 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try below expression</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><P>Sum </P><P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">LiefDatum</SPAN><SPAN style="font-size: 8pt;">), </SPAN><SPAN style="color: #800000; font-size: 8pt;">ShipID</SPAN><SPAN style="font-size: 8pt;">, </SPAN><SPAN style="color: #800000; font-size: 8pt;">AdrEmpf</SPAN><SPAN style="font-size: 8pt;">))<BR /></SPAN></P></BODY></HTML> Wed, 26 Nov 2014 12:41:00 GMT https://community.qlik.com/t5/QlikView/Problems-with-AGGR-function/m-p/824641#M473019 perumal_41 2014-11-26T12:41:00Z Re: Problems with AGGR function https://community.qlik.com/t5/QlikView/Problems-with-AGGR-function/m-p/824642#M473020 <HTML><HEAD></HEAD><BODY><P>why do you need to aggr, you can use normal count like =count(LiefDatum) and it will return 87, what is your need? </P></BODY></HTML> Wed, 26 Nov 2014 12:42:13 GMT https://community.qlik.com/t5/QlikView/Problems-with-AGGR-function/m-p/824642#M473020 maleksafa 2014-11-26T12:42:13Z Re: Problems with AGGR function https://community.qlik.com/t5/QlikView/Problems-with-AGGR-function/m-p/824643#M473021 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P></P><P>Thanks a lot!</P><P></P><P>Cheers</P><P>Oliver</P></BODY></HTML> Wed, 26 Nov 2014 12:44:44 GMT https://community.qlik.com/t5/QlikView/Problems-with-AGGR-function/m-p/824643#M473021 2014-11-26T12:44:44Z