topic Re: Load QVDs between two dates in QlikView

Load QVDs between two dates

viveksingh — Fri, 15 Nov 2024 23:56:24 GMT

Hi All,

I Have Multiple QVDs with similar names like SALES_1,SALES_2, SALES_3, SALES_4, SALES_5, SALES_6.....

I have to load only those QVDs that have a specific date range in between 20200101 and 20200520.

I tried below, but not working.

Let Vstart=Num(20200101 );

Let Vend=Num(20200520);

Sales:

Load *

from SALES*.qvd

where Num(Date) between $(Vstart) and $(Vend);

Re: Load QVDs between two dates

sunny_talwar — Tue, 22 Sep 2020 11:41:39 GMT

Try this for Vstart and Vend

LET Vstart = Num(MakeDate(2020, 1, 1)); LET Vend = Num(MakeDate(2020, 5, 20));

Re: Load QVDs between two dates

Vegar — Tue, 22 Sep 2020 12:05:10 GMT

Between is not a Qlik function you could use < and > instead.

LOAD *
FROM SALES*.qvd
WHERE Date >= $(Vstart) AND Date <= $(Vend)

You do also need to make sure that you are comparing the correct values. If your Date field is a date then you will probably need to do something like @sunny_talwar is suggesting above.

For reference, remember that

If today() = '20200922' then num(Today()) = 44096. This because 20200922 is only the text representation of the date not the numeric value of the date.

Re: Load QVDs between two dates

Kushal_Chawda — Tue, 22 Sep 2020 12:23:26 GMT

@viveksingh If your actual field value in data also holds the values like YYYYMMDD format then try below

Let Vstart=floor(date#(20200101,'YYYYMMDD'));

Let Vend=floor(date#(20200520,'YYYYMMDD'));

then try below where

Sales:

Load *

from SALES*.qvd

where floor(date#(Date,'YYYYMMDD')) >= $(Vstart) and floor(date#(Date,'YYYYMMDD')) <=$(Vend);

Re: Load QVDs between two dates

Brett_Bleess — Thu, 15 Oct 2020 21:03:13 GMT

@viveksingh You have some good responses here, we would greatly appreciate it if you could circle back to this thread and close things out by using the Accept as Solution button on the post(s) that helped, or if you figured out something different, you can post what you did and then mark that, but you may still want to "Like' the post(s) that did give you any help in figuring things out too. If you still need further assistance, please leave an update post.

Regards,
Brett