Slow Qlik document

[pauldamen]

All,

I have a Qlik document which loads from 3 QVD's (around 500.000 lines in total).

And I have 5 tabs with some objects, my problem is, it is extremely slow. Every time I make a selection it eats up all my CPU and takes forever to change.

What did I do wrong that makes the document that slow?

Regards,

Paul

[pauldamen]

That would be great, please find my QVD's attached. I also attached the QVW that creates the QVD's from the sources

[rustyfishbones]

Hi Paul,

Can you Comment out your Calendar Table and reload and let me know if that speeds up your Object calculations

Regards

Alan

[pauldamen]

It looked to be working, but as soon as I add a year field to the load it goes bananas again.

Should I create the year, month etc, fields also before the QVD creation?

[rustyfishbones]

Hi Paul,

I found a Date in the Data 1-0-2013, maybe that is causing an issue.

Also I recommend you don't join tables with Date as the link.

For now you should create the calendar fields from the Date in Main_Exp and get going again.

But try removing 1-0-2013 from the Main_Exp Date field, or fix it at source

[rustyfishbones]

Yes I would try adding at the Create QVD stage

[pauldamen]

Added the dates before the QVD creation, unfortunately it still remains slow

[rustyfishbones]

Hi Paul,

It appears the guys maybe correct.

you need to look at the expressions you are using in the charts

Regards

Alan

[jochem_zw]

You need to add a distinct to your Main_Dim

Main_Dim:

LOAD distinct CUSTCODE,

     MainAccount,

     Customer,

     HOLDING_KEY_NEW,

     Channels,

     [Ds Ids],

     CUSTOMER_ID,

     RatePlanCode,

     RatePlanName,

     Segment

FROM

Main_Dim.qvd

(qvd);