Loop for Qlikview

rassanbekov — Sat, 09 Dec 2017 16:29:32 GMT

Hello! I need to write a loop in Qlikview to use formula n times and generate output in separate field n times.

I did it in excel but For function does not work for me in Qlikview.

Could you please help with script?

You can access to macros in excel for further details.

Re: Loop for Qlikview

petter — Sun, 10 Dec 2017 16:25:06 GMT

You can try this load script - it is based on your spreadsheet's Input1 and Input 2:

INPUT:
LOAD RowNo() AS W#,* INLINE [
D6 E6
100 12
200 3
20 5
3000 0,500
60 0,125
188 1
11 666 1
1 400 1
300 1
111 1
1 255 12
500 2
10 2
200 2
4 000 2
5 000 3
50 3
456 3
780 3
800 3
500 4
400 4
200 4
100 4
100 4
100 5
100 5
100 5
100 5
100 5
100 5
3000 6
144 6
155 6
1 000 6
900 6
900 7
900 7
900 7
900 7
900 7
900 7
500 8
5 000 8
10 000 8
10 000 8
10 000 9
100 9
200 9
300 9
400 9
500 10
] (delimiter is \t);

FOR i=1 TO 20
  LOAD
    $(i) AS Sim#,
    Sum(J6*G6) AS Consequences
  ;
  LOAD
    G6,  // InputProduct
    IF(RAND()>F6,0,1) AS J6 // Random Value
  ;
  LOAD
    IF(E6>=4,0.95,E6/4) AS F6, //Probability,
    IF(E6>4,D6*E6/4,D6) AS G6  //InputProduct
  RESIDENT
    INPUT
;
NEXT

The three LOAD statements roll up into one single load with just some intermediate calculations in the load at line #67 and line #63. It is called PRECEDING load. They sort of piggy-tail.

topic Re: Loop for Qlikview in QlikView

Loop for Qlikview

Re: Loop for Qlikview