Inputfield doesn't work in straight table

[amber2000]

Hello,

I hope this time someone can help me please, I'm desperate

Inserting an inputfield in a table box works but when I try to use the inputfield in a straight table the field is static and can't be manipulated.

A tablebox is not sufficient enough because I want to be able to create Expressions.

Can anyone help please????

I've prepared a small QVW with a little bit of data to make my question a bit more visual.

Kind regards,

Monique

[richard_pearce6]

Hi Monique,

You need to add it as an expression

=InputSum(To_Give)

Regards

Richard

qlikcentral | Understand / Create / Inform

[sujeetsingh]

Go to these links

http://community.qlik.com/thread/39330

http://community.qlik.com/thread/102556

http://community.qlik.com/thread/97548

http://community.qlik.com/thread/34593

[#4 · Accepted solution]

Remove the dimension To_Give and add this expression:

=INPUTSUM(To_Give)

[amber2000]

Thanks a million Clark, this does the trick.

Monique

[amber2000]

Clark,

Do you know how I can exclude the Emp_Badge that has no records in the other table.

It looks like I made unwillingly a crossjoin and the records from table 1 that have no matching records in table 2 should not be displayed.

Monique

[#7]

To exclude it from the straight table you can check "Suppress When Value is Null" for the dimensions you are pulling from AseId6.

[amber2000]

Also works fine.

Can I ask one more thing about the inputfield?

I would like to add an inputfield where I can choose between two values (Yes, No) similar like a boolean.

How can I do that?

Monique

[#9]

Unfortunately, I don't believe that is possible. Additionally, the INPUTSUM expression will limit you to numeric inputs in the chart value. You could use a 1 or a 0 in the input field and add another expression to validate the input:

IF(To_Give=1,'Yes',if(To_Give=0,'No','Error'))

[richard_pearce6]

Hi Monique,

It's possible using a Macro:

ActiveDocument.Fields("FieldName").SetInputFieldValue <Table Row Number>, 'Yes'

Richard

qlikcentral.com