topic Re: Monthly QVD's from one DB and only create latest month QVD in QlikView

QVD Month Loop Problem

stevietm — Wed, 05 Apr 2017 06:50:26 GMT

Re-posted

Re: Monthly QVD's from one DB and only create latest month QVD

prma7799 — Wed, 05 Apr 2017 06:57:00 GMT

Hi Steive ,

Please check below link

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

Thanks

Re: Monthly QVD's from one DB and only create latest month QVD

stevietm — Wed, 05 Apr 2017 07:01:46 GMT

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.

Re: Monthly QVD's from one DB and only create latest month QVD

stevietm — Wed, 05 Apr 2017 07:06:10 GMT

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;

Re: Monthly QVD's from one DB and only create latest month QVD

Kushal_Chawda — Wed, 05 Apr 2017 07:19:16 GMT

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

Re: Monthly QVD's from one DB and only create latest month QVD

stevietm — Wed, 05 Apr 2017 08:15:04 GMT

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