Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

mrchmchr
New Contributor II

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
Esteemed Contributor

Re: Limit Table Download

Hi,

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

mrchmchr
New Contributor II

Re: Limit Table Download

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
Esteemed Contributor

Re: Limit Table Download

Sorry i was talking about the script..

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

Community Browser