QVD Month Loop Problem

[stevietm]

Re-posted

[prma7799]

Hi Steive ,

Please check below link

https://community.qlik.com/thread/48633

Thanks

[stevietm]

Thanks i will try this. The other question i had was - how do i create the history data to monthly QVD files. For instance, how do i create the loop to look at the history and export month by month to qvds for 4 years.

[stevietm]

Will this script work for that?

MyQvd:
LOAD *, Date(Date,'YYYYMM') as YearMonth 
FROM
source.qvd
(qvd);

Temp:
Load Distinct YearMonth
Resident Temp;

let Vm=NoOfRows('Temp');

for I=0 to $(Vm)-1;
LET vFileName=Peek('YearMonth',$(I),'Temp');

Table:

NoConcatenate
Load * resident MyQvd
where YearMonth = '$(vFileName)';

STORE  Table into $(vFileName).qvd (qvd);

drop table Table;
NEXT I;

DROP Table Temp, MyQvd;

[Kushal_Chawda]

see this

Creating Daywise QVDs

Using this you can create the day wise qvds and further you can create the Monthly qvds using daily qvds

[stevietm]

Is it possible to do this from the SQL DB  and not from a QVD - so far i can only see how people do it from existing QVD's, i want to it from the DB