Discussion Board for collaboration on QlikView Scripting.
i'm a newbie in using QlickView and i'm having some trouble creating a load script.
When i debug the script, system answers "Invalid expression" and i don't understand why...
Here is my code:
DTFprove.csv (txt, codepage is 1252, embedded labels, delimiter is ',', msq)
where AMOUNT > 0;
CALLING_IMSI as IMSI,
sum(AMOUNT) AS AMOUNT
RESIDENT dtf Group By CALLING_IMSI;
Thanks a lot!!!
Go to Solution.
sum(AMOUNT) AS TOTALAMOUNT
RESIDENT dtf Group By CALLING_IMSI, TARIFF_PLAN;
You forget to add Tariff_Plan in group by clause.
Thank you very much..
I think i have to study SQL statements much more...