Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Yes, optimized load if the QVD is created with 2.0.
Didn't find anything in the notes about this either.
I think this issue was solved a long time in version 2.0 and above