topic Re: Load Csv & Group by in QlikView

Load Csv & Group by

Mon, 22 Jul 2013 08:23:16 GMT

Hi everyone,

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:

dtf:

LOAD

CALLING_IMSI,

TARIFF_PLAN,

AMOUNT

FROM

DTFprove.csv (txt, codepage is 1252, embedded labels, delimiter is ',', msq)

where AMOUNT > 0;

Join (dtf)

LOAD

CALLING_IMSI as IMSI,

TARIFF_PLAN,

sum(AMOUNT) AS AMOUNT

RESIDENT dtf Group By CALLING_IMSI;

Thanks a lot!!!

tresB — Mon, 22 Jul 2013 08:35:43 GMT

try this:

dtf:

LOAD

CALLING_IMSI,

TARIFF_PLAN,

AMOUNT

FROM

DTFprove.csv (txt, codepage is 1252, embedded labels, delimiter is ',', msq)

where AMOUNT > 0;

Join (dtf)

LOAD

CALLING_IMSI as IMSI,

TARIFF_PLAN,

sum(AMOUNT) AS TOTALAMOUNT

RESIDENT dtf Group By CALLING_IMSI, TARIFF_PLAN;

suniljain — Mon, 22 Jul 2013 09:05:06 GMT

You forget to add Tariff_Plan in group by clause.

Mon, 22 Jul 2013 10:35:16 GMT

Thank you very much..

I think i have to study SQL statements much more...