topic Re: GROUP BY CLAUS in QlikView https://community.qlik.com/t5/QlikView/GROUP-BY-CLAUS/m-p/789150#M279039 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P>1. count(Aggr(Count(field_1),field_2))</P><P></P><P>2. Aggr( Count(field_1),field_2) </P><P></P><P></P><P>Regards</P><P>Av7eN</P><P></P><P></P></BODY></HTML> Fri, 07 Nov 2014 10:40:02 GMT aveeeeeee7en 2014-11-07T10:40:02Z GROUP BY CLAUS https://community.qlik.com/t5/QlikView/GROUP-BY-CLAUS/m-p/789148#M279037 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>i want to execute this request in text object:</P><P>select count(field_1),field_2&nbsp; group by field_2</P><P>how can i do that in qlikview???????</P></BODY></HTML> Fri, 07 Nov 2014 10:31:07 GMT https://community.qlik.com/t5/QlikView/GROUP-BY-CLAUS/m-p/789148#M279037 2014-11-07T10:31:07Z Re: GROUP BY CLAUS https://community.qlik.com/t5/QlikView/GROUP-BY-CLAUS/m-p/789149#M279038 <HTML><HEAD></HEAD><BODY><P>SUM(Aggr(COUNT(field_1),field_2))</P></BODY></HTML> Fri, 07 Nov 2014 10:31:41 GMT https://community.qlik.com/t5/QlikView/GROUP-BY-CLAUS/m-p/789149#M279038 MK_QSL 2014-11-07T10:31:41Z Re: GROUP BY CLAUS https://community.qlik.com/t5/QlikView/GROUP-BY-CLAUS/m-p/789150#M279039 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P>1. count(Aggr(Count(field_1),field_2))</P><P></P><P>2. Aggr( Count(field_1),field_2) </P><P></P><P></P><P>Regards</P><P>Av7eN</P><P></P><P></P></BODY></HTML> Fri, 07 Nov 2014 10:40:02 GMT https://community.qlik.com/t5/QlikView/GROUP-BY-CLAUS/m-p/789150#M279039 aveeeeeee7en 2014-11-07T10:40:02Z