Discussion board where members can get started with Qlik Sense.
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]
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%
[here any calculation done]
if("Mese"='42430', 0, ("Score"-Peek("Score", -1))/Peek("Score", -1)) as AAA.Delta%
Where is the problem? Which field should i have to use in case i renamed before them?
Thankyou very much!
Go to Solution.
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%;
Score as "AAA Score"
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.
the field you read is "Mese", not "AAA Mese" (replace with "Mese"
the same for Score
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.