topic Input Box updates variable vSeconds. Data duplicates X amount of times of vSeconds in QlikView

Input Box updates variable vSeconds. Data duplicates X amount of times of vSeconds

Thu, 29 Jun 2017 22:22:31 GMT

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

Re: Input Box updates variable vSeconds. Data duplicates X amount of times of vSeconds

kaushiknsolanki — Fri, 30 Jun 2017 07:40:12 GMT

Hi,

Do you want to do this in script or in frontend?

Regards,

Kaushik Solanki

Re: Input Box updates variable vSeconds. Data duplicates X amount of times of vSeconds

Fri, 30 Jun 2017 13:38:56 GMT

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.