topic Re: input filed in QlikView

input filed

usercapricon — Fri, 02 Mar 2018 07:05:27 GMT

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

Re: input filed

Chanty4u — Fri, 02 Mar 2018 07:08:17 GMT

i think input field will not work with " AS "

Re: input filed

usercapricon — Fri, 02 Mar 2018 07:13:34 GMT

so how i do that

Re: input filed

tamilarasu — Fri, 02 Mar 2018 07:20:35 GMT

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;

Re: input filed

usercapricon — Fri, 02 Mar 2018 07:22:26 GMT

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

Re: input filed

Chanty4u — Fri, 02 Mar 2018 07:26:49 GMT

here is the example given it will work the same

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

Re: input filed

tamilarasu — Fri, 02 Mar 2018 07:27:37 GMT

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