Export entire data from table

[Kirsten]

When I create a table I only have a small subset of my data visible. When I right click on the table and export to excel I only get the subset of this data that is visible in the table exported. How can I get the entire dataset exported?

Kirsten

[kaushiknsolanki]

Hi,

The easiest way is you remove all the filters/selections you have done and then export the data of the table.

[Kirsten]

hi @kaushiknsolanki 

Filters are already removed but the dataset is that large that not all data fits in the table. The not visible data doesn't get exported

[kaushiknsolanki]

Hi,

I understand what you are saying.  if you have larger data then 1048576  many rows then it may not download all data, because Qlik Sense export option uses Excel xlsx format which supports only 1048576  rows.