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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Limit number of rows in table to 10

I need to limit the number of rows in a table I am working on. My table looks like this:

DateCount 1Count 2Count 3
2017-12-06142716
2017-12-0522213
2017-12-04191911

Using a limitation on my dimension does not appear to work, as dimension limitations use a measure; I simply want the last 10 days to show up regardless of the values of the counts. I have read that Rank() might achieve what I am going for but I am not sure how it would work.

0 Replies