How to add input field in existing table like in the form in Access?

[#1]

Hi Ladies and gentleman,

Its Nice to use Qlikview. This is my first time requesting for very urgent help. Can anyone guide me how to insert entry field from existing table box or list box or charts and it would be updated in another table.I would very much appreciate this help...bec I have seen inline and input box it is not sufficient enough to help me.

Thanks

[kaushiknsolanki]

HI,

     Can you please explain us in detail what you want with example.

Regards,

Kaushik Solanki

[#3]

Hi sir,

Using the example below, lets say Coke ACS (kg) and Coke Inject I need to create an input field where it will update a table how do I defined it at Edit Script. Assuming this data table is residing at my folder in excel.The table below is in table box OR list box. And where the other tables are also associated by ID, date, Heat No.

ID	49113
Date	01-Nov-11
Shift	2300-0700
Group	C
Heat No	L11NH07679
Billet Wt (kg)	78515
Billet (pcs)	41
Coke ACS (kg)	896
Coke Inject (kg)	1440
Total Coke (kg)	2336

[kaushiknsolanki]

Hi,

     It can be achieved with definiing the field as Input Field.

     For more information on input field, go to help.

Regards,

Kaushik Solanki

[#5]

Hi Kaushik, I have tried to but my list box not increasing but I can replace 1 record any codes I need to add in ?

Below is the sample

//
////MS ACCESS IN AF6
//
inputfield ListOfFields;
where:
//
Inputfield ID;
Inputfield Date;
Inputfield Shift;
Inputfield [Group],
Inputfield [Heat No],
Inputfield [Billet Wt (kg)],
Inputfield [Billet (pcs)],
Inputfield [Coke ACS (kg)],
Inputfield [Coke Inject (kg)],

Directory;
LOAD ID as ID_Access,
     Date as Date_Access,
     Shift as Shift_Access,
     [Group],
     [Heat No],
     [Billet Wt (kg)],
     [Billet (pcs)],
     [Coke ACS (kg)],
     [Coke Inject (kg)],
     [Total Coke (kg)],
FROM
[..\2_ACCESS\AF6\EAF-6 Operation Record 0101_2401.xlsx]
(ooxml, embedded labels, table is [EAF-6 Operation Record-1]);

[#6]

Hi Kaushik, I have tried to but my list box not increasing but I can replace 1 record any codes I need to add in ?

Below is the sample

//
////MS ACCESS IN AF6
//
inputfield ListOfFields;
where:
//
Inputfield ID;
Inputfield Date;
Inputfield Shift;
Inputfield [Group],
Inputfield [Heat No],
Inputfield [Billet Wt (kg)],
Inputfield [Billet (pcs)],
Inputfield [Coke ACS (kg)],
Inputfield [Coke Inject (kg)],

Directory;
LOAD ID as ID_Access,
     Date as Date_Access,
     Shift as Shift_Access,
     [Group],
     [Heat No],
     [Billet Wt (kg)],
     [Billet (pcs)],
     [Coke ACS (kg)],
     [Coke Inject (kg)],
     [Total Coke (kg)],
FROM
[..\2_ACCESS\AF6\EAF-6 Operation Record 0101_2401.xlsx]
(ooxml, embedded labels, table is [EAF-6 Operation Record-1]);

[kaushiknsolanki]

Hi,

     Yes inputfield will allow you to change the loaded data.

     I guess this is what you are looking for?

Regards,

Kaushik Solanki

[#8]

Hi Kaushik, what if I need to add is there anything that I can add.

Thanks Azman

[kaushiknsolanki]

Hi,

     I didnt grt you, can you please explain it in detail?

Regards,

Kaushik Solanki

[#10]

The infield is helpful to ammend any record but what if I need to add new ones it does not seem to show addition in the listbox or table box. Thanks & Regards