30 Replies Latest reply: Jun 10, 2015 5:54 AM by Karl Fredberg RSS

    Where Exists on loading from QVD ?

    Bill Markham

      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