Problem InputField

[carlos13]

I'm trying to make a table with a inputField and do not know what does not work, someone has no idea what I'm doing wrong

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

You need to specify in the script which field you want to use as an inputfield. Assuming it's HORAS2, then the script should look like

INPUTFIELD HORAS2;
Tabla:
LOAD COD_FRM_REGISTRO_DET, 
     COD_FRM_REGISTRO, 
     COD_ACTIVIDAD, 
     COD_INDUCTOR, 
     HORAS, 
     HORAS as HORAS2, 
     ASIGNADO, 
     COD_SUBACTIVIDAD
FROM
FRM_REGISTRO_DETAIL.qvd
(qvd);

Hope that helps.

Miguel

[carlos13]

thank you very much

[robert99]

When I try this (in a demo to see if it works) it comes up with

duplicate key when loading input field

INPUTFIELD Cust2;

abc:

LOAD

CustRefNo,

Cust,

Cust as Cust2,

Call,

SerNo,

QVRespond as QVRespond,

Engineer

FROM

D:\QlikView2\TestSerialRH.xlsx

(ooxml, embedded labels, table is Sheet1);

[IVAN-FELIPE]

Hi,

Take care with these two points:

- Are you trying to use Inputfield with a non numeric field?, the inputfield only works for numeric data, verify all the elements are numeric and not null

- It just works when you don't have any repeated , for example a case like this should not work:

InputField SalesInput;    

CustId,SalesRep,SalesInput

     A1,Rep1,1000

     A1,Rep1,2000

If this is your case you can use a trick like including an extra index with the expression RowNo():

Inputfield SalesInput;

Sales:

Load RowNo() as NewIndex,

        CustId,

        SalesRep,

        Sales,

        Sales as SalesInput

from Sales.qvd(qvd);

[IVAN-FELIPE]

Hi,

Take care with these two points:

- Are you trying to use Inputfield with a non numeric field?, the inputfield only works for numeric data, verify all the elements are numeric and not null

- It just works when you don't have any repeated , for example a case like this should not work:

InputField SalesInput;    

CustId,SalesRep,SalesInput

     A1,Rep1,1000

     A1,Rep1,2000

If this is your case you can use a trick like including an extra index with the expression RowNo():

Inputfield SalesInput;

Sales:

Load RowNo() as NewIndex,

        CustId,

        SalesRep,

        Sales,

        Sales as SalesInput

from Sales.qvd(qvd);

[IVAN-FELIPE]

Hi,

Take care with these two points:

- Are you trying to use Inputfield with a non numeric field?, the inputfield only works for numeric data, verify all the elements are numeric and not null

- It just works when you don't have any repeated , for example a case like this should not work:

InputField SalesInput;    

CustId,SalesRep,SalesInput

     A1,Rep1,1000

     A1,Rep1,2000

If this is your case you can use a trick like including an extra index with the expression RowNo():

Inputfield SalesInput;

Sales:

Load RowNo() as NewIndex,

        CustId,

        SalesRep,

        Sales,

        Sales as SalesInput

from Sales.qvd(qvd);

[robert99]

Thanks ife

That worked

I used either a table box or list box to input the relevant data (not a table chart)

And it also worked with alpha columns. It was the RowNo() as NewIndex

that made the difference

This is a great feature.

[#9]

Hello community,

I have a problem, too:

Inputfield

  [DDV6I3WIO4DV98RHK9W24JQX9].[DDV6I3WIO4FEMHF07CRA9EJGT], //Liefertreue Auftragsmenge WLD

  [DDV6I3WIO4DV98RHK9W24JQX9].[DDV6I3WIO4G6B3QRIW6WBTXQL], //Retourenquote

  [DDV6I3WIO4DV98RHK9W24JQX9].[DDV6I3WIO4EMXV38VTBO6Z571]; //Servicegrad Mengen

[ZAUFMON/ZAUFKUZU]:

Load *;

Select PseudoMDX (

Dimensions (

  [0DISTR_CHAN] (),

  [0DIVISION] (),

  [0MATERIAL] (),

  [0PLANT] (),

  [0SALESORG] (),

  [0SOLD_TO] (),

  [0CALMONTH] ()),

Measures (

  [DDV6I3WIO4DV98RHK9W24JQX9].[DDV6K7POHGWTLJUCN989BEZNX], //KUZU>0?

  [DDV6I3WIO4DV98RHK9W24JQX9].[DDV6KISXJM0NIHI5DNX1TBTHP], //Kundenzufriedenheit

  [DDV6I3WIO4DV98RHK9W24JQX9].[DDV6I3WIO4GXZQ2IUFMIE9C0D], //Kundenzufriedenheit Menge

  [DDV6I3WIO4DV98RHK9W24JQX9].[DDV6I3WIO4FEMHF07CRA9EJGT], //Liefertreue Auftragsmenge WLD

  [DDV6I3WIO4DV98RHK9W24JQX9].[DDV6I3WIO4G6B3QRIW6WBTXQL], //Retourenquote

  [DDV6I3WIO4DV98RHK9W24JQX9].[DDV6I3WIO4EMXV38VTBO6Z571]), //Servicegrad Mengen

Whats wrong with that?

[#10]

im using inputfield  and script level i do the change on field manually.

but how can get previous data?

when i closed qvw and reopen it  the manual input records are there? plz help me?