Loading time

srinathy15 — Wed, 13 Nov 2019 15:22:47 GMT

While loading a data into qlikview, it takes 45 mins to load. What are the possible reasons for more loading time ???

Re: Loading time

Stoyan_Terziev — Wed, 13 Nov 2019 15:26:37 GMT

Hello Srinathy,

The most common reasons are:

1) Huge volume of data

2) Aggregation (Sum/Count/etc - basically everything which requires Group BY)

3) Complex filtration ( using multiple If / Not / AND/ OR conditions)

4) Using If() in a field usually slows it down but not tremendously

5) VLOOKUP is extremely slow function.

Try to put exit scripts in between steps and see which one runs the slowest. You can identify the problem based on what step takes most time.

I hope that helps!

Kind regards,

S.T.