Script sintax

canmarroig — Wed, 20 Apr 2011 10:01:15 GMT

Good morning, i've to build a SQL SELECT in order to merge two datas coming from different sources:

- a field coming from a file .xls
- another field coming from a ODBC

This will add the calculation of the margin range in the load script in order to use it in reports.

I started with a:

LEFT JOIN
LOAD

//of xls data to ODBC

//Billing Key is the common key

SELECT

,CASE
WHEN ROUND((a.Sales-b.Costs)/a.Sales,2) < -1 THEN 'less than -100%'
WHEN ROUND((a.Sales-b.Costs)/a.Sales,2) BETWEEN -.99 AND -.5 THEN 'FROM -100% and -50%'
.....

ELSE 'ND'
END AS [range]
FROM (SELECT Billing Key,SUM(Costs) AS (Costs) FROM Days GROUP BY Billing Key) b
ON a.Billing Key=b.Billing Key;

But i don't understand what's going wrong, perhaps this sintax isn't correct? Thank you for help

topic Script sintax in QlikView

Script sintax