Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

vikasshana
New Contributor III

Need help in Input box

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'.

DescValueResult(Value+Input Value)
A1020
B2030
C3040

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'.

DescValueResult(Value+Input Value)
A1020
B2020
C3030
1 Solution

Accepted Solutions
RonaldDoes
Contributor III

Re: Need help in Input box

Hi Bharath,

Would

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

work for you?

Naamloos.png

Please find the attached example.

Hope this helps you.

With kind regards,

Ronald

3 Replies
RonaldDoes
Contributor III

Re: Need help in Input box

Hi Bharath,

Would

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

work for you?

Naamloos.png

Please find the attached example.

Hope this helps you.

With kind regards,

Ronald

pradosh_thakur
Honored Contributor II

Re: Need help in Input box

may be something similar to this

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

regards

Pradosh

Learning never stops.
vikasshana
New Contributor III

Re: Need help in Input box

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.

Community Browser