topic Loop in load script in QlikView https://community.qlik.com/t5/QlikView/Loop-in-load-script/m-p/342717#M126572 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a dataset with collections fields NewCD1, NewCD2,...........NewCDn</P><P></P><P>These are boolian variables i.e. 0 or 1 </P><P></P><P>What I want to do is create a counter that starts at NewCDn and loops backwards to NewCD1 and aggregate a CollectionsCount variable.</P><P>However I want the CollectionsCount to stop if NewCD is false and output this value.</P><P></P><P>I also need the number of variables for NewCDn to be dynamic. What I mean is that I dont want the user to have to ammend the number of variables in the loop. It must automatically start at the last field every time.</P><P></P><P>I am fairly new to Qlikview so any assitance would be appreciated.</P><P></P><P>Thanks!</P></BODY></HTML> Tue, 10 Jul 2012 09:24:30 GMT 2012-07-10T09:24:30Z Loop in load script https://community.qlik.com/t5/QlikView/Loop-in-load-script/m-p/342717#M126572 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a dataset with collections fields NewCD1, NewCD2,...........NewCDn</P><P></P><P>These are boolian variables i.e. 0 or 1 </P><P></P><P>What I want to do is create a counter that starts at NewCDn and loops backwards to NewCD1 and aggregate a CollectionsCount variable.</P><P>However I want the CollectionsCount to stop if NewCD is false and output this value.</P><P></P><P>I also need the number of variables for NewCDn to be dynamic. What I mean is that I dont want the user to have to ammend the number of variables in the loop. It must automatically start at the last field every time.</P><P></P><P>I am fairly new to Qlikview so any assitance would be appreciated.</P><P></P><P>Thanks!</P></BODY></HTML> Tue, 10 Jul 2012 09:24:30 GMT https://community.qlik.com/t5/QlikView/Loop-in-load-script/m-p/342717#M126572 2012-07-10T09:24:30Z Re: Loop in load script https://community.qlik.com/t5/QlikView/Loop-in-load-script/m-p/342718#M126573 <HTML><HEAD></HEAD><BODY><P>Do you have a sample of this dataset?</P></BODY></HTML> Wed, 11 Jul 2012 04:49:12 GMT https://community.qlik.com/t5/QlikView/Loop-in-load-script/m-p/342718#M126573 Anonymous 2012-07-11T04:49:12Z