Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
thank you very much
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);
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);
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);
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);
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.
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?
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?