topic Need help in Input box in QlikView

Need help in Input box

vikasshana — Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

Need your help in one of the requirement, I've created a variable and an input box where user can able to enter a value and can see the change in the straight table. Everything is working fine and the values are changing for the entire table but I want to see the change for a particular row rather than the whole table. Below are the examples.

Example - This is what I'm getting.

input value is '10'.

Desc	Value	Result(Value+Input Value)
A	10	20
B	20	30
C	30	40

This is what I want to see in the straight table where the value has been changed for only the first row where Desc='A'.

Desc	Value	Result(Value+Input Value)
A	10	20
B	20	20
C	30	30

Re: Need help in Input box

RonaldDoes — Tue, 17 Oct 2017 14:40:04 GMT

Hi Bharath,

Would

=Sum(Value)+If(Desc='A', vSomeVariable,0)

work for you?

Please find the attached example.

Hope this helps you.

With kind regards,

Ronald

Re: Need help in Input box

pradosh_thakur — Tue, 17 Oct 2017 15:16:22 GMT

may be something similar to this

if(Desc='A',Value+Input Value,Value)

regards

Pradosh

Re: Need help in Input box

vikasshana — Tue, 17 Oct 2017 15:50:18 GMT

Thank you Ronald and Pradosh, I've modified the expression as below and is working fine.

=Count(Distinct Fieldname)+If(Desc='A', vSomeVariable,0).

Thanks again for your help guys.