Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Hi,
Do you want to do this in script or in frontend?
Regards,
Kaushik Solanki
Preferable front end? I'm happy to try to do both but don't want to reload data when I change vSecond. I'd like the data to duplicate after user changes the variable, and refresh the results after new input box value given.