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
