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

expected output:

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.

basically, like in excel we apply formulas =() in the cells and based on the formulas values get dynamically calculated on the go. So exactly same feature I need in qlikview

Any help will be appreciated.

Thank you

[bgerchikov]

Hi Urmil!

Not sure how you will populate user input column, but calculated formula for "new result" column will be as follows

[result]+[quantity(user input)]

Thanks!

[oscar_ortiz]

You will need to create the input field in the script first.

Then you can input values into the input field via a table box object.

Finally you can use the expression Boris mentioned

Good luck!

Oscar

[vishsaggi · Accepted solution]

Try this?

INPUTFIELD FieldName;

Table:

LOAD *, 1 AS FieldName INLINE [

Name, Result

ABC, 10

ABC, 15

XYZ, 25

DCE, 45

ADC, 55

];

Using Straight table:

Add Dim as Name

Expr: Inputsum(FieldName) -> Label this as Ifield

= Sum(Result) + Ifield -> Label this as New result

Test file attached.

[bgerchikov]

Yes, something like this.