Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
marcelostb
Partner - Contributor
Partner - Contributor

How can I generate a huge EXCEL with 2000 columns?

I need to read a QVD and generate information that will be migrated to EXCEL.

The EXCEL table will have 1000 rows and 2000 columns. Each line of EXCEL will consist of a single code and each line will have 2000 columns, that indicates a specific information calculated from the QVD .

The QVD source has about 2 million records .

For example :

line 1 =  info 1

col 1 = sum ( occurrences ) where M = genre;

col 2 = sum ( occurrences ) where genre = F

col 3 = sum ( occurrences ) where age> 60

...

col 2000 = sum ( occurrences ) where local = X;

We did a test generating a TABLE object in QVW, using "info" as dimension with 3 expressions (3 columns) and it worked.

The concern is if the number of columns (2000) will result in problems (mainly performance) or is there another better to do the process .

Thanks for helping

Looking forward ,

Siffert (ADITI)

0 Replies