Loading one QVD multiple time and storing it

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

Hello All,

I have one qvd where I want to filter the data for the month of March irrespective of the year((01-03-2017,01-03-18 ). After filtering the data, I want to repeat the same data for 12 month.

For example, If my closing balance of Apple was 100 for the month March,01-03-2018 then the 100 should come to next 12 months Like 01-04-2018 should have 100 as my opening balance,01-05-2018 should have 100 as my opening balance and so no.

Data:

LOAD * Inline [

Start_Date,Data,Category

01-Mar-17,100, Apple

01-Mar-18,110, Apple

01-Mar-19,200, Apple

];

Kindly help me to achieve this.

Thanks in advance.

Regards,

Re: Loading one QVD multiple time and storing it

prieper — Mon, 17 Sep 2018 16:49:33 GMT

aircode:

FOR i = 0 TO 11
LOAD ADDMONTHS(Start_Date, $(i)) AS Start_Date, Data, Category FROM .... WHERE MONTH(Start_Date) = 3;

NEXT i

topic Re: Loading one QVD multiple time and storing it in QlikView

Loading one QVD multiple time and storing it

Re: Loading one QVD multiple time and storing it