How-to reference - load data from QVD

[BrianDH]

Hi

I used SQL script to create 2 QVD files.  Voucher & Voucher Line.

Now how do I pull just the fields I need from each / format / filter "Where"?

I have linked the 2 qvd files using the Data manager.  But I just want data, as example, data for the year 2018.  Enter _Date => '' and  Enter _Date <=  ''

How do I pull the data out of the QVD to use in a report?

Sorry but this is my first effort.

[Vegar · Accepted solution]

You could start with this. Hopefully your Enter_Date is recognised as a date field.

LOAD

   *

FROM

   LIB:\YourQvdLib\voucher.qvd (qvd)

WHERE

Year(  Enter_Date) = 2018

;

[BrianDH]

So can I do??

LOAD Field1, Field 12, Field13 ...

FROM 

LIB:\YourQvdLib\voucher.qvd (qvd)

WHERE

Year(  Enter_Date) = 2018

[BrianDH · Accepted solution]

Qlik Tutorial Script

[brijendra_singh]

Yes you can select the column which you want