Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasshana
Creator II
Creator II

How to store data from a QVD into individual monthly QVD's using Date field

Hi,

I've data from 2021 in my main QVD, my requirement is how to store the data into individual monthly QVD's using Date field.

Regards,

V

 

2 Replies
Hania
Creator
Creator

Hi

I think you can store monthly QVD from your based QVD.

you can try this,

When you load data from your QVD then add Where condition  into it and extract month & year based data ,

& store it into QVD.

lly, you have to do for all months 

so you will get QVD on Monthly basis.

below is the logic that I have applied on my sample data.

 

FROM [lib://  Path Location .qvd]
(qvd) where Month(date_field ) = 'Feb' and year( date_field ) = 2019; 

Store Table_Name  into [lib:// Path Location /Feb_2019.qvd](qvd);
Drop Table Table_Name;

 

Hope this helps,

help user find answers ! don't forget to mark  a solution that work for you and click the like button!