Add a blank field

[gfisch13]

I'm trying to understand if QV will support placing a field in a blank field in a table, thinking this needs to be done in the load script.

Would it be possible to turn that new field into some type of user input field to mark a record as reviewed?

Ideally - I'm trying to create a workpaper. Just trying to understand if this is even possible or I'm spinning my wheels. Thanks, George

[Kushal_Chawda]

Can you please elaborate?

[gfisch13]

Sure.......the attached is a view in its simplest form.   

I have a list of purchase order numbers, next to that I'd like to place a blank field which I can probably do in excel, but, I'd like to allow the user to put some entry next to the purchase order number that he already reviewed so that he doesn't have to look at it again. 

I'm just not sure if QV allows this activity and have not found much text regarding it.

Appreciate the help Kush!

[Brett_Bleess]

Believe you are referring to Input Fields:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/Input...

Design blog post that may be of some help too:

https://community.qlik.com/t5/Qlik-Design-Blog/Loading-Data-into-Input-Boxes/ba-p/1469453

Regards,
Brett

[Saravanan_Desingh]

Try using INPUTFIELD. This will provide you to edit the Field.

INPUTFIELD Reviewed;

tab1:
LOAD * INLINE [
    Purchase Order, Reviewed
    111111
    222222
    333333
    444444
    555555
    666666
];

[gfisch13]

If I use the INPUTFIELD as you mention, can the user then fill that field with any value?  I'm thinking that I would also be able to filter on the values of that field?

[gfisch13]

Thanks Brett - this gets me part of the way there, and is an option I didn't realize existed.  Thanks for the input.

[gfisch13]

when I try to add the INPUTFIELD to my script, its generating a 'Field Not Found' error.    I'm trying to add the field to one of my tables, is this syntax incorrect?   Thanks!

(see attached)

[Brett_Bleess]

Check out this other Help link, there are some examples there etc., hopefully that will help you confirm things:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/Scrip...

I am not all that great at the development questions myself, more of a backend/server guy, sorry.  Hopefully one of the others that is better at it will stop by again and provide some additional guidance.

Cheers,
Brett

[Kushal_Chawda · Accepted solution]

You need to add field as blank value. It will give you error as you don't have such a field in your data so you need to create it like below

inputfield Reviewed;

EMEACitiData:

LOAD *,

          '' as Reviewed

FROM Data;