Dynamically change values based on user input

[#1]

Hello Everyone,

I am new to qlikview. I have following scenario

Name	quantiy(User_input)	result	new result
ABC		10
ABC		15
XYZ		20
PQR		35
LMN		45

Name	quantiy(User_input)	result	new result
ABC	2	10	12
ABC	3	15	18
XYZ	5	20	25
PQR	10	35	45
LMN		45

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

[ahaahaaha]

Hi,

May be like in attached file.

To enter data, move the mouse cursor to the right side of the desired cell until the icon shown in the figure below appears.

Regards,

Andrey