
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
load multiple qvd
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi,
please provide how your files and data are available, then what is your output from that.
ksrinivasan.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If you are looking the similar to SQl, You can use Today()-1 in Qlik
