topic Re: Need help on this loop? in QlikView

Need help on this loop?

Tue, 14 Apr 2015 18:06:46 GMT

Hi Folks,

I have a business like ABC,XYZ,KKK,MMM every business having the data from apr-2014 to mar-2015.and each business is coming from one table.

here for each business i am using the loop here.

for each vBusiness in ABC,XYZ,KKK,MMM

call new_business(startdate,business,tablename,enddate)

next vBusiness

I have a each call statement for each business.i want to generate the data in loop.

maxgro — Tue, 14 Apr 2015 18:30:11 GMT

for each vBusiness in 'ABC','XYZ','KKK','MMM'

trace $(vBusiness);

table_$(vBusiness):

load

'$(vBusiness)' as business,

date(makedate(2014,4) + rowno()-1) as date

AutoGenerate

makedate(2015,3,31)-makedate(2014,4)+1;

STORE * from table_$(vBusiness) into table_$(vBusiness).qvd (qvd);

drop table table_$(vBusiness);

next;

Wed, 15 Apr 2015 07:00:04 GMT

Hi,

Thanks for ur reply

here i have the call statement

i need to execute that call statement for each business.

like below

let startdate='01-04-2014';

let enddate='01-04-2015';

I have these business- ABC,XYZ,KKK,MMM

Here for each business is coming from each seperate tables so for each business i have one table here.

assume that ABC- ABC_Tab

XYZ- XYZ_Tab

KKK- KKK_Tab

MMM - MMM_Tab

call new_business(startdate,ABC,ABC_Tab,enddate)

call new_business(startdate,XYZ,XYZ_Tab,enddate)

call new_business(startdate,KKK KKK_Tab,enddate)

call new_business(startdate,MMM,MMM_Tab,enddate)

next vBusiness