Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
groveliam
Contributor

Only load certain dates from qvd

Is there a way to only load in certain dates from a qvd? I need it to only read in the last 60 days, month ends, and January 2nd. Right now I have tried:

let MinDate = Date((Today() - 60), 'YYYY-MM-DD');

let monthEnds = Date(MonthEnd(AddMonths(today()-60,-1)), 'YYYYMMDD');

    Load * From [lib://Files\Deposit.qvd] (qvd)

    where [Production Date] >= $(MinDate);

  

    Concatenate

    Load * From [lib://Files\Deposit.qvd] (qvd)

    where [Production Date] <= $(monthEnds);

but this does not seem to affect the dates loaded in at all. Any help is appreciated!

Thanks,

Liam Grover

1 Solution

Accepted Solutions

Re: Only load certain dates from qvd

May be create a list of dates using AutoGenerate  and then use Where Exists... something like this

Table:

LOAD Today() - IterNo() + 1 as [Production Date]

AutoGenerate 1

While IterNo() <= 60;

Concatenate (Table)

LOAD Floor(MonthEnd(Today() - 60, -IterNo()+1) as [Production Date]

AutoGenerate 1

While IterNo() <= 20; -> You can Change this number based on how far back you wish to go

Concatenate (Table)

LOAD Num(MakeDate(2018, 1, 2)) as [Production Date]

AutoGenerate 1;

FactTable:

Load * From [lib://Files\Deposit.qvd] (qvd)

where Exists([Production Date]);

DROP Table Table;

This will also ensure that you have an optimized load from your qvd file.

2 Replies

Re: Only load certain dates from qvd

May be create a list of dates using AutoGenerate  and then use Where Exists... something like this

Table:

LOAD Today() - IterNo() + 1 as [Production Date]

AutoGenerate 1

While IterNo() <= 60;

Concatenate (Table)

LOAD Floor(MonthEnd(Today() - 60, -IterNo()+1) as [Production Date]

AutoGenerate 1

While IterNo() <= 20; -> You can Change this number based on how far back you wish to go

Concatenate (Table)

LOAD Num(MakeDate(2018, 1, 2)) as [Production Date]

AutoGenerate 1;

FactTable:

Load * From [lib://Files\Deposit.qvd] (qvd)

where Exists([Production Date]);

DROP Table Table;

This will also ensure that you have an optimized load from your qvd file.

groveliam
Contributor

Re: Only load certain dates from qvd

Thank you for the quick answer that worked great!