load multiple qvd

[Luben]

how do i load multiple QVD files into one table. The QVD’S have millions on data how do i filter data to get at least 1 month data versus getting the entire data. 

for example in sql would be sysdate - 1. 

is there a function like that in qlik sense

[Ksrinivasan]

hi,

if, is there any date sequence then you can use 

load,

from lib\\:202001*.qvd

2020-yesr

01-jan month

even your file data format 20200101

ksrinivasan

[Luben]

Thanks for your response, i do not have a date sequence in my data.  Any idea how to work around it. In one of the QVD files it has calendar information could i use that to filter the rest of the QVD am loading.

Thanks

[Ksrinivasan]

hi,

please provide how your files and data are available, then what is your output from that.

ksrinivasan.

[Anil_Babu_Samineni]

If you are looking the similar to SQl, You can use Today()-1 in Qlik