2 Replies Latest reply: Jun 30, 2017 9:38 AM by Bryan Van RSS

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

    Bryan Van

      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