Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Remove the dimension To_Give and add this expression:
=INPUTSUM(To_Give)
Hi Monique,
You need to add it as an expression
=InputSum(To_Give)
Regards
Richard
Remove the dimension To_Give and add this expression:
=INPUTSUM(To_Give)
Thanks a million Clark, this does the trick.
Monique
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
To exclude it from the straight table you can check "Suppress When Value is Null" for the dimensions you are pulling from AseId6.
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
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'))
Hi Monique,
It's possible using a Macro:
ActiveDocument.Fields("FieldName").SetInputFieldValue <Table Row Number>, 'Yes'
Richard
qlikcentral.com