topic LOAD Count distinct script in QlikView

LOAD Count distinct script

Thu, 20 Feb 2014 10:08:05 GMT

Hi all,

i'm trying to create a new table in a Load Script after loading a file, but i have an "Invalid Expression" error on the Count function.

Could you please help me?

I need to count the number of item for each value of "tariff_plan"..

Here is an extract of the code:

dtf:

LOAD

CALLING_IMSI,

(if(CALLING_IMSI='',CALLED_IMSI, CALLING_IMSI)) as IMSI_def,

CALLED_IMSI,

TARIFF_PLAN,

if(EVENT_TYPOLOGY='Data',QUANTITY/(1024*1024),QUANTITY) as QUANTITY

FROM

C:\253.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

plans:

LOAD

TARIFF_PLAN,

count(distinct(IMSI_def)) as talking

resident dtf;

Re: LOAD Count distinct script

Anonymous — Thu, 20 Feb 2014 10:10:14 GMT

dtf:

LOAD

CALLING_IMSI,

(if(CALLING_IMSI='',CALLED_IMSI, CALLING_IMSI)) as IMSI_def,

CALLED_IMSI,

TARIFF_PLAN,

if(EVENT_TYPOLOGY='Data',QUANTITY/(1024*1024),QUANTITY) as QUANTITY

FROM

C:\253.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

plans:

LOAD

TARIFF_PLAN,

count(distinct(IMSI_def)) as talking

resident dtf

group by TARIFF_PLAN

;

You forgot to add group by statement due to which it was showing error.

Regards

Nitin

Re: LOAD Count distinct script

Thu, 20 Feb 2014 10:11:59 GMT

plans:

LOAD

TARIFF_PLAN,

count(distinct(IMSI_def)) as talking

resident dtf

group byTARIFF_PLAN

Re: LOAD Count distinct script

er_mohit — Thu, 20 Feb 2014 10:21:19 GMT

write like this

plans:

LOAD Distinct

TARIFF_PLAN,

count( IMSI_def) as talking

resident dtf group by TARIFF_PLAN ;