Qlik Community

Qlik Deployment Framework

This group hosts information related to the Qlik Deployment Framework (QDF). Providing best practices, libraries and utilities that facilitate the recommended setup and management of QlikView or Qlik Sense environments. An understanding of the Qlik platform is recommended before joining this group. Download QDF and documentation here: https://github.com/QlikDeploymentFramework/Qlik-Deployment-Framework/releases

Highlighted
rthamman
New Contributor III

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

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 

 

Tags (1)
1 Reply
Partner
Partner

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

HI there,

One way to achieve this is using a calculation condition.

calccondition.png

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