Dynamically change values based on user input

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Dynamically change values based on user input

ahaahaaha — Mon, 19 Jun 2017 15:05:17 GMT

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

topic Re: Dynamically change values based on user input in QlikView

Dynamically change values based on user input

Re: Dynamically change values based on user input