Where Exists on loading from QVD ?

[Anonymous]

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

[#2]

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

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

[pablolabbe]

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