topic loop qvd qlikview in QlikView

loop qvd qlikview

Anonymous — Wed, 23 Dec 2015 14:31:22 GMT

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 ?

Re: loop qvd qlikview

sunny_talwar — Wed, 23 Dec 2015 14:38:16 GMT

jaweher89 wrote:

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

Not sure I understand your question.

Re: loop qvd qlikview

marcus_sommer — Wed, 23 Dec 2015 14:44:43 GMT

Try:

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');
if filesize('E:\QVD\QVD\Vente_$(vMth)_$(vYr).qvd') > 0 then
trace QVD exists already;
else
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);
end if
NEXT
drop table MONTHLYSPLIT ,Dates;

- Marcus