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

Where Exists on loading from QVD ?

Hi

[This follows on from thread Qlik Sense takes almost three times longer to reload than QlikView but I am creating a new thread as this question is purely regarding Where Exists on loading from QVD]

I have created a test QVD using :

Transactions:

Load

TransLineID,

TransID,

mod(TransID,26)+1 as Num,

Pick(Ceil(3*Rand1),'A','B','C') as Dim1,

Pick(Ceil(6*Rand1),'a','b','c','d','e','f') as Dim2,

Pick(Ceil(3*Rand()),'X','Y','Z') as Dim3,

Round(1000*Rand()*Rand()*Rand1) as Expression1,

Round(  10*Rand()*Rand()*Rand1) as Expression2,

Round(Rand()*Rand1,0.00001) as Expression3;

Load

Rand() as Rand1,

IterNo() as TransLineID,

RecNo() as TransID

Autogenerate 10000000

While Rand()<=0.5 or IterNo()=1;

store Transactions into TransactionQV112.qvd (qvd) ;

Then loaded it with a Where Exists as per below :

Temp:

LOAD * INLINE [

    Expression1

    1

];

Transactions:

load * from  TransactionQV112.qvd (qvd)

Where Exists (Expression1)

;

It seems as if in QlikSense the Where Exists is ignored and the whole QVD is loaded.

Whereas in QlikView the Where Exist is used and only the required rows are loaded.

Any ideas anybody ?

Best Regards,     Bill

31 Replies
Not applicable
Author

Yes, optimized load if the QVD is created with 2.0.

Didn't find anything in the notes about this either.

pablolabbe
Luminary Alumni
Luminary Alumni

I think this issue was solved a long time in version 2.0 and above