Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Load Csv & Group by

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!!!

L.

Tags (3)
1 Solution

Accepted Solutions
MVP
MVP

Re: Load Csv & Group by

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;

3 Replies
MVP
MVP

Re: Load Csv & Group by

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
Honored Contributor

Re: Load Csv & Group by

You forget to add Tariff_Plan in group by clause.

Not applicable

Re: Load Csv & Group by

Thank you very much..

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

Community Browser