Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
usercapricon
Contributor
Contributor

input filed

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

1 Solution

Accepted Solutions
tamilarasu
Champion
Champion

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;

View solution in original post

6 Replies
Chanty4u
MVP
MVP

Hi

i think input field will not work with " AS "

usercapricon
Contributor
Contributor
Author

so how i do that

tamilarasu
Champion
Champion

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
Contributor
Contributor
Author

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
MVP
MVP

here is the example given  it will work the same

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

tamilarasu
Champion
Champion

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