topic Re: Count Function while Loading Excel in QlikView

Count Function while Loading Excel

Thu, 15 May 2014 05:58:50 GMT

LOAD No,

Customerid,
Count(Customerid) as Count,

From XXXXx

I would like to Count Number of customer while lodaing using scrip. Please help me.

Re: Count Function while Loading Excel

MK_QSL — Thu, 15 May 2014 06:01:51 GMT

Try as below

LOAD

     No,
     Customerid,
    Count(Customerid) as Count,

From XXXXx

Group By No, Customerid;

Load

Customerid,

Count(Customerid) as Count

From xxxx

Group By Customerid;

Re: Count Function while Loading Excel

Thu, 15 May 2014 06:09:26 GMT

Hi Manish,

I tried the above code but getting the following error. I am using trail version is that the case?

Re: Count Function while Loading Excel

MK_QSL — Thu, 15 May 2014 06:11:03 GMT

Try

Load

No,

Customerid,

Count(Customerid) as Count

all otherfield....

From ....

Group By No, Customerid, all other fields also except Count(Customerid);

You need to add all fields in Group By

Re: Re: Count Function while Loading Excel

ashfaq_haseeb — Thu, 15 May 2014 06:16:10 GMT

Hi try Below

Temp:

Load

No,

Customerid,

all otherfield....

From ....

Main:

Load

No,

Customerid,

Count(Customerid) as Count

all otherfield....

resident Temp

Group By No, Customerid, all other fields also except Count(Customerid);

Drop table Temp;

Regards

ASHFAQ

Re: Count Function while Loading Excel

Thu, 15 May 2014 06:23:16 GMT

Load

No,

CostumerID,

count(CustomerID) as Count

from ...

group by No, CostumerID

just in case you have some other fields you want to load you also have to put it in the group by statement.

regards,

Re: Count Function while Loading Excel

Thu, 15 May 2014 06:32:02 GMT

Hi Thanks

I am trying to write code to create a list box with Product Name and count of number of Customerids like the graph below. The purpose is to create custom list boxes using the Script and visualize them. Can I write SQL scripts in Qlikview.??????