Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
annick
Contributor III
Contributor III

Limit the number of lines displayed in a table

Hello,

I would like to display only the first 10 lines in my table with the following colums:

- Sales Date

- Product ID

- Vendor ID

- Nb of Sales

Is there a way to achieve this?

Thanks

Kind regards

Labels (2)
1 Reply
BrunPierre
Partner - Master
Partner - Master

@annick Perhaps an expression as below with the other columns as dimensions.

=If(RowNo(TOTAL) <= 10, Sum([Nb of Sales]))