topic Re: Add a blank field in QlikView

Add a blank field

gfisch13 — Sat, 16 Nov 2024 18:18:24 GMT

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

Re: Add a blank field

Kushal_Chawda — Mon, 27 Jul 2020 21:26:46 GMT

Can you please elaborate?

Re: Add a blank field

gfisch13 — Tue, 28 Jul 2020 12:00:05 GMT

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!

Re: Add a blank field

Brett_Bleess — Tue, 11 Aug 2020 18:34:50 GMT

Believe you are referring to Input Fields:

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

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

Re: Add a blank field

Saravanan_Desingh — Tue, 11 Aug 2020 20:29:35 GMT

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 ];

Re: Add a blank field

gfisch13 — Wed, 12 Aug 2020 12:10:46 GMT

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?

Re: Add a blank field

gfisch13 — Wed, 12 Aug 2020 12:11:48 GMT

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

Re: Add a blank field

gfisch13 — Wed, 12 Aug 2020 12:42:16 GMT

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)

Re: Add a blank field

Brett_Bleess — Wed, 12 Aug 2020 14:50:35 GMT

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/ScriptPrefixes/Inputfield.htm

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

Re: Add a blank field

Kushal_Chawda — Wed, 12 Aug 2020 14:56:30 GMT

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;

Re: Add a blank field

gfisch13 — Wed, 12 Aug 2020 17:04:56 GMT

This worked perfectly, thank you.

But now I have to adjust something since every record is being shown in my table box. I'd rather have one record per ID. How could I accomplish that?

see attached.....

Re: Add a blank field

Kushal_Chawda — Wed, 12 Aug 2020 21:15:16 GMT

You can create distinct recorof employee ID by creating new field

inputfield Reviewed;

Data:

load *,

Employee ID

FROM Source;

DistinctEmployee:

load distinct Employee ID,

Employee ID as Distinct_Employee,

'' as Reviewed

resident Data;

Now use Distinct_Employee field in tablebox

Re: Add a blank field

gfisch13 — Thu, 13 Aug 2020 12:27:36 GMT

Thanks Kush - appreciate the help, exactly what I was looking for!