Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
Hi
i think input field will not work with " AS "
so how i do that
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;
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
here is the example given it will work the same
Join on table containing input fields - a bug ? | Qlik Community
Have a look at the attached file. This is working fine. Maybe your sample file help me to find the issue.