Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
khan_imran
Creator II
Creator II

Loading one QVD multiple time and storing it

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,

IK

1 Reply
prieper
Master II
Master II

aircode:

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

NEXT i