loop qvd qlikview

[Anonymous]

with the following script I split a huge big table in a  small QVD per year-month

Dates: 
LOAD DISTINCT 
Year, Month

RESIDENT Calendrier;

LET vNoOfMthsYrs = NoOfRows('Dates'); 


FOR i = 0 TO $(vNoOfMthsYrs) - 1 


LET vMth = PEEK('MONTH', $(i), 'Dates'); 
LET vYr = PEEK('YEAR', $(i), 'Dates'); 
MONTHLYSPLIT: 
LOAD 


* RESIDENT Vente WHERE MONTH( [Date Time]) = '$(vMth)' AND YEAR( [Date Time]) = '$(vYr)'; 

STORE MONTHSPLIT INTO E:\QVD\QVD\Vente_$(vMth)_$(vYr).qvd (qvd); 

NEXT 

   drop table MONTHLYSPLIT ,Dates;

How could I read loop successively over qvd that I ready created ?

[sunny_talwar]

jaweher89 wrote:
How could I read loop successively over qvd that I ready created ?

Not sure I understand your question.

[marcus_sommer]

Try:

1. Dates:  
2. LOAD DISTINCT  
3. Year, Month 
4.    
5. RESIDENT Calendrier; 
6.  
7. LET vNoOfMthsYrs = NoOfRows('Dates');  
8.  
9.  
10. FOR i = 0 TO $(vNoOfMthsYrs) - 1  
11.  
12.  
13. LET vMth = PEEK('MONTH', $(i), 'Dates');  
14. LET vYr = PEEK('YEAR', $(i), 'Dates');  
16. if filesize('E:\QVD\QVD\Vente_$(vMth)_$(vYr).qvd') > 0 then
17. trace QVD exists already;
18. else
20. MONTHLYSPLIT:  
21. LOAD  
22.  
23.  
24. * RESIDENT Vente WHERE MONTH( [Date Time]) = '$(vMth)' AND YEAR( [Date Time]) = '$(vYr)';  
25.  
26. STORE MONTHSPLIT INTO E:\QVD\QVD\Vente_$(vMth)_$(vYr).qvd (qvd);  
27.   end if
29. NEXT  
30.  
31.    drop table MONTHLYSPLIT ,Dates;

- Marcus