input filed

[usercapricon]

i am trying to add input filed but this is not working

INPUTFIELD table.Amount1;

Directory;

Data:

LOAD Group,

     Sales,

     [RowNo(TOTAL)]

FROM

test1.xls

(biff, embedded labels, table is Sheet1$);

Left Join (Data)

Load *,

Sales As Amount1

Resident Data;

Store Data Into Data.qvx;

any solution

[Chanty4u]

Hi

i think input field will not work with " AS "

[usercapricon]

so how i do that

[tamilarasu · Accepted solution]

Hello,

I am not sure why are using "table.Amount1" as input field name where as it should be "Amount1". Are you qualifying the "Amount1" field?

Try.

INPUTFIELD Amount1;

Directory;

Data:

LOAD Group,

     Sales,

     [RowNo(TOTAL)]

FROM

test1.xls

(biff, embedded labels, table is Sheet1$);

Left Join (Data)

Load *,

Sales As Amount1

Resident Data;

Store Data Into Data.qvx;

[usercapricon]

hi

i do this and remove table.amount . my updated script

INPUTFIELD Amount1;

Directory;

Data:

LOAD Group,

     Sales,

     [RowNo(TOTAL)]

FROM

test1.xls

(biff, embedded labels, table is Sheet1$);

Left Join (Data)

Load *,

Sales As Amount1

Resident Data;

Store Data Into Data.qvx;

but this is not working

[Chanty4u]

here is the example given  it will work the same

Join on table containing input fields - a bug ? | Qlik Community

[tamilarasu]

Have a look at the attached file. This is working fine. Maybe your sample file help me to find the issue.