Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Syntax error, missing/misplaced (Trying to create a new field)

Hi,

Im trying to create a new field within another field. I have a field called Sales forecast which Budget forecast belongs to as an element. I would like to save 'Budget Forecast' (which is in the field [Sales Forecast]) as an own field. When i try to do this in the qv import script i get two error messages: Syntax error, missing/misplaced and table not found. Can anyone please help me to spot what is wrong with the code?

Thank you

Regards

Glenn

Budget_import:


LOAD [Product Type],
[Sales Forecast],
Division,
Customer,
Time,
[Customer Revenues]
FROM

(ooxml, embedded labels, table is [Budget Sales Forecast]);

Budget_Field:
Load
[Product Type],
[Sales Forecast],
If([Sales Forecast]='Budget Forecast 2010',[Customer Reveneus])as budget
Divsion,
Customer,
Time,
[Customer Revenues]

Resident Budget_import;

Drop Table Budget_import;

2 Replies
Not applicable
Author

you forgot a comma sign after the "buget"

Not applicable
Author

Hi again,

Thanks for the quick reply. The comma problem is now fixed 🙂

However, I still get the "table not found problem"

Table not found
Budget_Field:
Load
[Product Type],
[Sales Forecast],
If([Sales Forecast]='Budget Forecast 2010',[Customer Reveneus])as budget,
Divsion,
Customer,
Time,
[Customer Revenues]

Resident Budget_import