Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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

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

2 Replies

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

Hi,

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

Regards,

Kaushik Solanki

Not applicable

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

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.

Community Browser