topic Re: load multiple qvd in App Development

load multiple qvd

Luben — Mon, 20 Dec 2021 21:05:46 GMT

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

Re: load multiple qvd

Ksrinivasan — Sun, 24 Jan 2021 13:53:12 GMT

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

Re: load multiple qvd

Luben — Sun, 24 Jan 2021 14:31:13 GMT

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

Re: load multiple qvd

Ksrinivasan — Sun, 24 Jan 2021 15:34:28 GMT

hi,

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

ksrinivasan.

Re: load multiple qvd

Anil_Babu_Samineni — Sun, 24 Jan 2021 16:43:34 GMT

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