Limit Qlik Sense Straight table to fetch first 1000 records

[#1]

Hello,

I have a straight table that is 3 million rows of IDs. Is there a way for me to limit the straight table so that it only pulls in the first 1,000 records?

I know this was possible in Qlikview, but have not found a way to do so in Qlik Sense.

Thank you

[sunny_talwar · Accepted solution]

May be using If statement..

If(RowNo(TOTAL) <= 1000, YourExpression)

[#3]

Thank you, this is exactly what I was looking for!

[Imbue20]

Hi sunny,

My query is almost the same, i need to show some initial 5k records in table which has nearly 5M records. But once user selects any filter like company code then the records should show according to selection( even the records can be 20k). Once the filter is removed again the table should show initial 5k records.

Please help me out.