Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to add new line(s) in cycle ?

Table loaded from excel looks like that

Nr. Count. Sum.

1 1 10

2 1 10

3 1 10

4 2 20

6 1 10

7 4 40

11 1 10

I need add line(s) after line where count > 1. Add count - 1 lines with Nr. = Nr.+ 1. and sum = sum/count. To get in final somthing like that:

Nr. Count. Sum.

1 1 10

2 1 10

3 1 10

4 1 10

5 1 10

6 1 10

7 1 10

8 1 10

9 1 10

10 1 10

11 1 10

1 Solution

Accepted Solutions
Oleg_Troyansky

Look at " LOAD ... WHILE" syntax, in conjunction with function "IterNo()" - those two will help you solve the problem.

Oleg

View solution in original post

2 Replies
Oleg_Troyansky

Look at " LOAD ... WHILE" syntax, in conjunction with function "IterNo()" - those two will help you solve the problem.

Oleg

Not applicable
Author

Thank, Oleg.