Generating multiple qvd

sunil1989 — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

Thanks in advance!!!!

My requirement is that i have two variable vStartDate And vEndate,

For example I have pass date to these variables vStartDate = 04-05-2017 and vEndate = 08-05-2017.

and my query is

$(vTableName):
SQL
SELECT * FROM $(vTableName)

where DAY_KEY >= $(vStartDate)
and DAY_KEY <= $(vEndDate);

and it should store the data for each day in diffrent qvd for example:

$(vTableName)_04-05-2017.qvd

$(vTableName)_05-05-2017.qvd

$(vTableName)_06-05-2017.qvd

$(vTableName)_07-05-2017.qvd

$(vTableName)_08-05-2017.qvd;

topic Generating multiple qvd in QlikView