Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Using RowNo() Every Row shows 1

This is probably very simple for someone. My rowno() function is showing 1 for every row.

More detail:

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?

Labels (1)
1 Reply
Not applicable
Author

Because each row is unique to the dimensions. If you want a running total, then use:

RowNo(TOTAL)


That gives the row number ignoring the dimensions.