I have a pretty complicated code to find out the valid cost_center for every employee for every single day from his/her join_date to (his/her leaving_date or today).
The code works for one single employee, I have thoroughly tested it on a few quite difficult scenarios and it was correct all the way.
Now I've made this into a subroutine and built a FOR...NEXT loop over the employees and call this subroutine once per line (Í pass the line_nr to the subroutine, not the emp_ID, I think that simple consecutive numbers are easiest for QlikView and thus fastest)
=> The code runs error-free through all lines of the employee_list.`
The only remaining problem - I hope it's the only one remaining - is: The loops goes like
FOR i = 1 TO NoOfRows('Tablename')
CALL ...
NEXT
At the end of this, I just wanted to have a look at my counter i to see if it had the right value and I saw just that nr. of variables there - one variable labeled '1', one labeled '2' and so on all the way through to 1.000+
Is there some way I can drop those along the way?
Thanks a lot!
Best regards,
DataNibbler
P.S.: I create several variables in every run of the subroutine, with both SET and LET
- The variables really have the same name and value - the variable labeled '1' has the value 1, the one labeled '2' has the value 2 and so on.
=> I suppose this is the line_ID that I pass to the subroutine:
- This is actually my counter i that I use in the loop
- I call the sub like >>> CALL Kostenstellenroutine ($(i)) <<<
=> The sub itself begins like >>> sub Kostenstellenroutine (v_lineID) <<<
=> The counter i is thus passed to the sub labeled v_lineID.
=> I suppose, but unfortunately I cannot check, that this variable that is left over with every single call of the sub is just this counter.
In another thread on a similar issue, I found that >>> LET [var] = NULL(); <<< could be used <=> I cannot do that because I cannot use the semicolon or my LOOP will stop right there.
I guess, though, that those variables cost me very little in terms of performance, so I can just build a second LOOP and delete them all?
P.S.: No, obviously it was not that - that second LOOP seemingly did not even execute.
no, it is surely not necessary - the problem is, all of these variables just have a number as label - I cannot tell at which point in the code they are actually generated.
I will have another look at the SET and LET commands in the code - I believe there are several.
I had it with that $-sign-expansion as >>> $(i) <<< (I had understood, from "QlikView 11 for Developers" that you should just ALWAYS use it (necessary or not) just to keep things in sync.
