topic How to apply grouping in qlikview expression? in QlikView https://community.qlik.com/t5/QlikView/How-to-apply-grouping-in-qlikview-expression/m-p/333295#M1170437 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>Can anyone help, please?</P><P></P><P>I have some fields </P><P>field1</P><P>field2</P><P>field3</P><P>field4</P><P>field5</P><P>....</P><P></P><P>I need field5 for max(field4) group by field1, field2, filed3 in a chart.&nbsp; </P><P></P><P>Thanks!</P></BODY></HTML> Thu, 02 Aug 2012 03:14:25 GMT 2012-08-02T03:14:25Z How to apply grouping in qlikview expression? https://community.qlik.com/t5/QlikView/How-to-apply-grouping-in-qlikview-expression/m-p/333295#M1170437 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>Can anyone help, please?</P><P></P><P>I have some fields </P><P>field1</P><P>field2</P><P>field3</P><P>field4</P><P>field5</P><P>....</P><P></P><P>I need field5 for max(field4) group by field1, field2, filed3 in a chart.&nbsp; </P><P></P><P>Thanks!</P></BODY></HTML> Thu, 02 Aug 2012 03:14:25 GMT https://community.qlik.com/t5/QlikView/How-to-apply-grouping-in-qlikview-expression/m-p/333295#M1170437 2012-08-02T03:14:25Z Re: How to apply grouping in qlikview expression? https://community.qlik.com/t5/QlikView/How-to-apply-grouping-in-qlikview-expression/m-p/333296#M1170438 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>Try like (As dimnsion):</P><P></P><P>aggr(if(field4= max(field4), field5),field1,field2,field3) </P><P></P><P>Regards</P><P></P><P>Rahul Lakhina </P></BODY></HTML> Thu, 02 Aug 2012 08:13:52 GMT https://community.qlik.com/t5/QlikView/How-to-apply-grouping-in-qlikview-expression/m-p/333296#M1170438 2012-08-02T08:13:52Z