
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Data Load Editor - Field Not Found - Qlik Sense
Hi everyone!
I am completely new to Qlik Sense, and i'm struggling with a auper easy task in the data load editor.
I am loading a table (from excel) and doing this the program show me the error "Field Not Found", or it does not do any calculation. Hereafter the 2 cases:
[here error: "AAA MESE" FIELD NOT FOUND]
LOAD
Date("Mese",'MMMM-YY') as "AAA Mese",
Score as "AAA Score",
if("AAA Mese"='42430', 0, ("AAA Score"-Peek("AAA Score", -1))/Peek("AAA Score", -1)) as AAA.Delta%
FROM ....
[here any calculation done]
LOAD
Date("Mese",'MMMM-YY') as "AAA Mese",
Score as "AAA Score",
if("Mese"='42430', 0, ("Score"-Peek("Score", -1))/Peek("Score", -1)) as AAA.Delta%
FROM ....
Where is the problem? Which field should i have to use in case i renamed before them?
Thankyou very much!
Andrea
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can use a preceding LOAD to avoid repeating all your transformation expressions, like in:
LOAD *, IF("AAA Mese"='42430', 0, ("AAA Score"-Peek("AAA Score", -1))/Peek("AAA Score", -1)) as AAA.Delta%;
LOAD
Date("Mese",'MMMM-YY') as "AAA Mese",
Score as "AAA Score"
FROM ....
The first LOAD will use each row produced by the second LOAD as a source to perform further transformations. The resulting table will contain every row produced by the first LOAD.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
[here error: "AAA MESE" FIELD NOT FOUND]
LOAD
Date("Mese",'MMMM-YY') as "AAA Mese",
Score as "AAA Score",
if("AAA Mese"='42430', 0, ("AAA Score"-Peek("AAA Score", -1))/Peek("AAA Score", -1)) as AAA.Delta%
FROM ....
the field you read is "Mese", not "AAA Mese" (replace with "Mese"
the same for Score


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
LOAD
Date("Mese",'MMMM-YY') as "AAA Mese",
Score as "AAA Score",
if("AAA Mese"='42430', 0, ("AAA Score"-Peek("AAA Score", -1))/Peek("AAA Score", -1)) as AAA.Delta%
FROM ....
You can't refer to "AAA Mese" in the if statement. That field doesn't exist until the load is complete. You'll get the same error for "AAA Score" in the same line.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can use a preceding LOAD to avoid repeating all your transformation expressions, like in:
LOAD *, IF("AAA Mese"='42430', 0, ("AAA Score"-Peek("AAA Score", -1))/Peek("AAA Score", -1)) as AAA.Delta%;
LOAD
Date("Mese",'MMMM-YY') as "AAA Mese",
Score as "AAA Score"
FROM ....
The first LOAD will use each row produced by the second LOAD as a source to perform further transformations. The resulting table will contain every row produced by the first LOAD.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I'm having a similar issue. What would be the work around to be able to use a new created field in the if statement? Thank you
