Hi Qlik community. Hoping to get advice on how to execute the following. Want to have a input box that duplicates the existing data x amount of times. I attempted this initially with AutoGenerate but it produces excess data which isn't desirable. I've tried various methods of peek that calls on vSecond.
Any help would be appreciated.
Thank you,
Bryan
TransactionTable:
load * inline [
Trade, Time, Amount
a,3,100
b,5,250
c,25,-50
];
Table
Trade | Time | Amount |
A | 3 | 100 |
B | 5 | 250 |
C | 25 | -50 |
Input Box = 4 |
Trade | Time | TimeDuration | Time DurationLimit | Amount |
A | 3 | 3 | 7 | 100 |
A | 3 | 4 | 7 | 100 |
A | 3 | 5 | 7 | 100 |
A | 3 | 6 | 7 | 100 |
B | 5 | 5 | 9 | 250 |
B | 5 | 6 | 9 | 250 |
B | 5 | 7 | 9 | 250 |
B | 5 | 8 | 9 | 250 |
C | 25 | 25 | 29 | -50 |
C | 25 | 26 | 29 | -50 |
C | 25 | 27 | 29 | -50 |
C | 25 | 28 | 29 | -50 |
