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]

That sounds great

[#3]

Hello All,

We have also faced similar issue and one of my team member posted this in forum with heading

QlikSense-Issue with LeftKeep ,Exists and Trim

We were able to resolve this issue using trim() function.

However we also thought it should be fixed from QS with the next release.

Hope this helps.

Thank you.

Regards,

Chenna

[Michael_Tarallo]

Hi Chenna - I am addressing this as well with R&D

Mike T

Qlik

[#5]

Hi Mike,

Any news about optimized load with Where Exists() from QVDs created with Qlik Sense?

For some reason it stopped working with QVDs created with Qlikview.

Regards

Karl

[Michael_Tarallo]

Hi Karl, sorry for the delay.

I checked our tracking system and it shows that this has been fixed in our next release, due out this summer.

Let me know if you have any other questions.

Regards,

Mike Tarallo

Qlik

[#7]

Hi Mike,

Good news, hope it's early summer rather than late summer

I've been working in Qlik Sense Server for a while and have alot of suggestions for improvment. Which is the right way to submit those suggestions?

One perferomances improvement that annoys me right now is that you can't limit a dimension with the first records only top or bottom. When working with straight tables with multiple dimensions and measures it would be very useful, so the user can sort on the different columns but only show the first number of rows, like you could in Qlikview.

Cheers

Karl

[Michael_Tarallo]

Hi Karl - this is great information. I just added the "Ideas" section content to the forum:(click this link ->) New to Qlik Sense - let me know if you can "Create an idea" - with the information you described. I will make sure it gets in the proper hands.

Update me as soon as you have done so, or if you have an issue.

Kinds Regards,

Mike T

[#9]

It works great!

[#10]

It's seems to be fixed in 2.0 Release Preview.

Now it says the load is optimized from a row-based qvd. I think it said columnar in 1.1. I'm posting a question about that.

//Karl

[daniel_s-cubed]

Hi Karl,

Does it mean that you now get an optimized load also when using the where exists() function?

I can't find it any where in the release notes though.

Thanks

Daniel