Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Slow Document - 12 million rows

Hi,

I have a document with 12 million rows, 3 columns. Extracted from a optimized QVD.

I have two list boxes and one pivot with a count of id's in the document.

It takes about a minute to make one selection. I find this extremly slow.

Any ideas on how I can improve this.

11 Replies
Clever_Anjos
Employee
Employee

Task Manager / Performance

Anonymous
Not applicable
Author

Count of id's?

Try This

LOAD

Field1,

Field2,

Field3,

'1' as Counter

FROM YourSource;

And in the pivot table change the expression for Sum(Counter), the function sum takes less time to execute