Limit the number of records in the table and export full data- Qlik Sense

[rthamman]

Hi,

Is there a way in Qlik Sense to limit the number of records in a table (chart) and then export all the records in the excel sheet? Please post if there is a way to do it. 

-Apeksha 

[albertovarela]

HI there,

One way to achieve this is using a calculation condition.

Normally I use this with a very large data sets to only render the object with x number rows. 

If(sum(#RecordCounter) > X , 0, -1)   

I hope you find this helpful

Cheers