topic how to create dynamic rows in QlikView https://community.qlik.com/t5/QlikView/how-to-create-dynamic-rows/m-p/631093#M231611 <HTML><HEAD></HEAD><BODY><P>i have a requirement where i have to put a dynamic serial no. column.i have used the expression aggr(rowno(total)field name).now,there are 2 different sectors.this expression works fine for only one sector.can anyone suggest better expression which'll work for both sectors?</P><P>p.s. the field name above in the expression is not the sector field,although i've tried with the sector field too and still hasn't worked properly.</P><P>cheers</P></BODY></HTML> Tue, 13 May 2014 10:16:28 GMT 2014-05-13T10:16:28Z how to create dynamic rows https://community.qlik.com/t5/QlikView/how-to-create-dynamic-rows/m-p/631093#M231611 <HTML><HEAD></HEAD><BODY><P>i have a requirement where i have to put a dynamic serial no. column.i have used the expression aggr(rowno(total)field name).now,there are 2 different sectors.this expression works fine for only one sector.can anyone suggest better expression which'll work for both sectors?</P><P>p.s. the field name above in the expression is not the sector field,although i've tried with the sector field too and still hasn't worked properly.</P><P>cheers</P></BODY></HTML> Tue, 13 May 2014 10:16:28 GMT https://community.qlik.com/t5/QlikView/how-to-create-dynamic-rows/m-p/631093#M231611 2014-05-13T10:16:28Z