Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
pauloandre_rj
Contributor II
Contributor II

Erro ao baixar dados do ambiente Sense SaaS

Prezados,

o ambiente Sense Saas está apresentando erro na tentativa de baixar informações de uma tabela com 7900 linhas e 20 colunas e não existe a opção de cultivo em CSV.

Essa situação é muito utilizada pelos usuários da empresa. Teria augum ajustar a ser realizado??

Lembrando que pelo View não havia limitação de exportação

erro-exportacao.jpg

Labels (1)
  • SaaS

1 Solution

Accepted Solutions
Vinay_B
Support
Support

Hi @pauloandre_rj,

 

There are limitations on exporting the data from Qlik SaaS Environment. They are listed here:

 

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Download/downloading-vis... 

 

With regards to exporting as CSV, below are the limitations:

 

  • Map visualization data cannot be downloaded. 
  • Box plot, distribution plot and histogram data contains multiple hypercubes which would correspond to multiple sheets in Excel. When you download data, the default hypercube is only downloaded as a single sheet.
  • When downloading data from a table, styling is not preserved. This includes colors, fonts, hyperlinks, and more.
  • The Excel file cannot have more than:
    1048566 rows
    16384 columns
  • The size of the downloaded Excel file cannot exceed 100 MB. File size will depend on:
    The number of columns and rows
    The total amount of cells
    The amount of text in the cells
  • The total amount of cells cannot be determined beforehand.

I would suggest adding some filters before downloading the content to reduce the size.

 

Vinay

If this resolves your query, please click on "Accept as Solution" for confirmation. Thanks!

View solution in original post

1 Reply
Vinay_B
Support
Support

Hi @pauloandre_rj,

 

There are limitations on exporting the data from Qlik SaaS Environment. They are listed here:

 

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Download/downloading-vis... 

 

With regards to exporting as CSV, below are the limitations:

 

  • Map visualization data cannot be downloaded. 
  • Box plot, distribution plot and histogram data contains multiple hypercubes which would correspond to multiple sheets in Excel. When you download data, the default hypercube is only downloaded as a single sheet.
  • When downloading data from a table, styling is not preserved. This includes colors, fonts, hyperlinks, and more.
  • The Excel file cannot have more than:
    1048566 rows
    16384 columns
  • The size of the downloaded Excel file cannot exceed 100 MB. File size will depend on:
    The number of columns and rows
    The total amount of cells
    The amount of text in the cells
  • The total amount of cells cannot be determined beforehand.

I would suggest adding some filters before downloading the content to reduce the size.

 

Vinay

If this resolves your query, please click on "Accept as Solution" for confirmation. Thanks!