Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

1 Solution

Accepted Solutions
tresesco
MVP
MVP

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;

View solution in original post

3 Replies
tresesco
MVP
MVP

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

You forget to add Tariff_Plan in group by clause.

Not applicable
Author

Thank you very much..

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