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!
