Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
stevietm
Creator
Creator

QVD Month Loop Problem

Re-posted

5 Replies
prma7799
Master III
Master III

Hi Steive ,

Please check below link

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

Thanks

stevietm
Creator
Creator
Author

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
Creator
Creator
Author

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
Creator
Creator
Author

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