Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Please can anyone help me understand why my script won't load. The error message Qlik Sense gives me points to a filed as the problem, but I can see this field in the frontend dashboard, so it is clearly loading. What is wrong with my syntax? I've attached a screenshot to better illustrate this script.
CONCATENATE(CostValue)
LOAD
Text("Placement ID") as "Placement ID",
// "Date",
Date(Date#("Date",'YYYY-MM-DD'),'DD/MM/YYYY') as Date,
(Sum(Impressions)/1000) * 9.46 as [Cost-Per-Day]
FROM [lib://Output Files/Openreach/GCM/*.qvd] (qvd)
WHERE Match ([Site (DCM)],'crimtan.com','Programmatic Ads - Crimtan Agency') AND MATCH(NotesOne,'Phase1&2')
GROUP BY Date, "Placement ID";
Hi,
as you are loading all qvds in that folder (using *.qvd), they are processed one by one, but at least one of them doesn't have the field NotesOne.
This is your problem.
JG
Hi,
as you are loading all qvds in that folder (using *.qvd), they are processed one by one, but at least one of them doesn't have the field NotesOne.
This is your problem.
JG
thank-you 🙂