Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Limit Table Download

Hi everyone,

I am trying to limit the number of rows that are downloaded from a table.

The tabel is created "on the fly" via app.visualization.create('table',...) and the download is initiated via table.exportData(...).

Therefore I see two potential working points for limiting the number of rows, the table object itself and the exportData function. However I could not figure out how to implement this functionality.

As of now I just dump the complete download in a Blob and get rid of the unnecessary rows there. However when the Dataset is large this becomes a performance issue, so I really would like to get rid of the abundant rows before initiating the download.

Has anyone some advice on how to takle this issue?

Best,

Marco

3 Replies
YoussefBelloum
Champion
Champion

Hi,

can't you use WHERE at the end of the load before the export ??

Anonymous
Not applicable
Author

Hey Youssef,

thaks for your response, but could you please elaborate what you mean with end of load?

Are you refereing to the load script of the underlying qlik application?

That would unfortunately not help me as I am performing the download on the client side.

Or is there a way I can use it within js?

Best,

Marco

YoussefBelloum
Champion
Champion

Sorry i was talking about the script..

don't know if you can do it within Js..