topic Using RowNo() Every Row shows 1 in QlikView https://community.qlik.com/t5/QlikView/Using-RowNo-Every-Row-shows-1/m-p/235097#M86386 <HTML><HEAD></HEAD><BODY><P>This is probably very simple for someone. My rowno() function is showing 1 for every row.</P><P>More detail:</P><P>I have a straight table with several dimensions and expressions and am trying to get a running total for sales. I first tried to accumulate the sales and it works when changing to a graph but not in data form (straight table). So I decided to try rangesum and above functions which did not work. So I tried rowno() and see that every row shows as 1. This is obviously why it is not working. Any ideas why the rows are not recognized as a unit?</P></BODY></HTML> Fri, 07 May 2010 17:40:19 GMT Anonymous 2010-05-07T17:40:19Z Using RowNo() Every Row shows 1 https://community.qlik.com/t5/QlikView/Using-RowNo-Every-Row-shows-1/m-p/235097#M86386 <HTML><HEAD></HEAD><BODY><P>This is probably very simple for someone. My rowno() function is showing 1 for every row.</P><P>More detail:</P><P>I have a straight table with several dimensions and expressions and am trying to get a running total for sales. I first tried to accumulate the sales and it works when changing to a graph but not in data form (straight table). So I decided to try rangesum and above functions which did not work. So I tried rowno() and see that every row shows as 1. This is obviously why it is not working. Any ideas why the rows are not recognized as a unit?</P></BODY></HTML> Fri, 07 May 2010 17:40:19 GMT https://community.qlik.com/t5/QlikView/Using-RowNo-Every-Row-shows-1/m-p/235097#M86386 Anonymous 2010-05-07T17:40:19Z Using RowNo() Every Row shows 1 https://community.qlik.com/t5/QlikView/Using-RowNo-Every-Row-shows-1/m-p/235098#M86387 <HTML><HEAD></HEAD><BODY><P>Because each row is unique to the dimensions. If you want a running total, then use:</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">RowNo(TOTAL)</PRE></BLOCKQUOTE><BR /><BR /> <P>That gives the row number ignoring the dimensions.</P></BODY></HTML> Fri, 07 May 2010 18:21:41 GMT https://community.qlik.com/t5/QlikView/Using-RowNo-Every-Row-shows-1/m-p/235098#M86387 2010-05-07T18:21:41Z