I have a dataset with collections fields NewCD1, NewCD2,...........NewCDn
These are boolian variables i.e. 0 or 1
What I want to do is create a counter that starts at NewCDn and loops backwards to NewCD1 and aggregate a CollectionsCount variable.
However I want the CollectionsCount to stop if NewCD is false and output this value.
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.
I am fairly new to Qlikview so any assitance would be appreciated.
