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
Hi Guys - I just checked - the issue has been fixed in our next release, I don't have a time-frame exactly - but would imagine it will be early next year during Q1.
HTH
Mike
Try
Temp:
LOAD * INLINE [
Expression1
1
];
Transactions:
load * from TransactionQV112.qvd (qvd)
Where Exists (Round(1000*Rand()*Rand()*Rand1))
;
use drop statement
Temp:
LOAD * INLINE [
Expression1
1
];
Transactions:
load * from TransactionQV112.qvd (qvd)
Where Exists (Expression1)
;
drop table Temp;
Michael,
Do you know if this bug is fixed in release 1.02 of Qlik Sense? (couldn't find it in the release notes of 1.02)
Bram
Hi Bram - I just verifed that it is fixed in version 1.1 due out shortly.
Mike
Michael,
Do you know if this bug is fixed in version 1.1? There is nothing in the release notes of 1.1...
Or is there an alternative way to implement incremental loads?
Bram
Hi Bram - It shows fixed in the system - are you still seeing the same problems with 1.1?
Mike
Hi, Mike,
I've created QVDs in Qlik Sense 1.1 and loaded them from another Qlik Sense app with Where EXISTS() but the load isn't optimized. Why is that?
Without the EXISTS it is a optimized load.
//Karl
Hi Alkesh - I will send this over and see what is going on.
Mike
Hello Alkesh - got confirmation today - boy our team is Quick! 🙂
They said it is a bug and it is being addressed. I am not sure, but the fix COULD be in our next service releases. Stay tuned.
Mike T
Qlik