topic Re: Problem InputField in QlikView

Problem InputField

carlos13 — Thu, 15 Mar 2012 20:34:50 GMT

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

Re: Problem InputField

Miguel_Angel_Baeyens — Thu, 15 Mar 2012 20:50:02 GMT

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

Problem InputField

carlos13 — Thu, 15 Mar 2012 20:57:43 GMT

thank you very much

Re: Problem InputField

robert99 — Sat, 30 Jun 2012 19:22:17 GMT

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

Re: Problem InputField

IVAN-FELIPE — Wed, 11 Jul 2012 10:54:48 GMT

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

Re: Problem InputField

IVAN-FELIPE — Wed, 11 Jul 2012 10:55:03 GMT

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

Re: Problem InputField

IVAN-FELIPE — Wed, 11 Jul 2012 10:55:20 GMT

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

Re: Problem InputField

robert99 — Thu, 12 Jul 2012 08:06:55 GMT

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.

Re: Problem InputField

Tue, 13 Nov 2012 16:16:01 GMT

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?

Re: Problem InputField

Thu, 17 Apr 2014 06:04:35 GMT

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?