Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

marcelostb
New 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)

Tags (2)