Export to excel_urgent

[#1]

Hello Community,

I have 20 million rows in a straight table. When I export to excel my QVW file stops responding.

Also the performance and response time is not user friendly. The tool size is 436 MB and I, now, have to add this straight table.

I know Excel cannot handle so much data. Can anyone give me a way about this?

Also, Can anyone suggest me a checklist so that I could improve the performance. Exporting to excel is high priority for me. Please reply asap...

Thanks,

Vishal

[#2]

Hey Victor,

How do I export in QlikView script?

Do you have a code or script for that?

Considering I have a table with Object ID (for eg:)  'ST12'

[#3]

You export using STORE instruction but you can only export to CSV format not XLS or XLSX

[#4]

I need an example of your current data model to give you more information.

[#5]

Sorry Victor it is difficult to provide the data model.., I have nine dimensions in the table and six expressions. I want to export the contents of the table.

I hope this info is useful

Regards,

Vishal

[#6]

Then you aren't using a Straight Table , but a Simple Table Chart.   Without the data model it's dificult to tell you but I think you should make calculations in script rather than in an object to improve performance.  You must aggregate calculations in this way

LOAD DIM1,DIM2,DIM3,DIM4,DIM5,DIM6,DIM7,DIM8,DIM9, CALC1,CALC2,-----,CALC6

GROUP BY DIM1,DIM2,DIM3,DIM4,DIM5,DIM6,DIM7,DIM8,DIM9;

IF some selection is made to achieve the table you must apply WHERE filter.

ALL DIMS and FIELDS must be in one table.

Then store to CSV.