1 Reply Latest reply: Jun 19, 2017 11:05 AM by Andrey Khoronenko RSS

    Dynamically change values based on user input

    Urmil Maru

      Hello Everyone,

       

      I am new to qlikview. I have following scenario

       

      Name quantiy(User_input)resultnew result
      ABC10
      ABC15
      XYZ20
      PQR35
      LMN45

       

       

      Name quantiy(User_input)resultnew result
      ABC21012
      ABC31518
      XYZ52025
      PQR103545
      LMN45

       

       

      Like excel, upon entering values in quantiy(User_input)  (on the go/dynamically) column ,the "new result" column  should display the values it is simple addition of (quantity + result). I think there should be some way to create this using variables but I am not being able to develop this. Moreover inputsum function would not work as I want the values for individual rows. Any help will be appreciated.

       

      Thank you