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

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

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

Re: Dynamically change values based on user input

bgerchikov — Thu, 15 Jun 2017 19:58:28 GMT

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!

Re: Dynamically change values based on user input

oscar_ortiz — Thu, 15 Jun 2017 20:05:57 GMT

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

Re: Dynamically change values based on user input

vishsaggi — Thu, 15 Jun 2017 20:10:15 GMT

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.

Re: Dynamically change values based on user input

bgerchikov — Thu, 15 Jun 2017 20:35:52 GMT

Yes, something like this.