topic Re: Comulate Customers in QlikView

Comulate Customers

Fri, 09 Mar 2012 10:31:23 GMT

Hi All!

I have a problem.

I have a table with dates and customer ids.

I would like to create a chart which shows how many customers bought a product.

Data:

Date	Customer ID
2012.01.01.	A
2012.01.01.	B
2012.01.01.	C
2012.01.02.	A
2012.01.02.	D
2012.01.03.	A
2012.01.03.	B
2012.01.03.	C
2012.01.04.	E

The result will be something like this:

2012.01.01. 3 (different customers bought product)

2012.01.02. 4 (different customers bought product)

2012.01.03. 5 (different customers bought product)

etc...

Please help me!

Thanks

Re: Comulate Customers

Fri, 09 Mar 2012 10:32:22 GMT

The last row date is 2012.01.03. too.

Re: Comulate Customers

CELAMBARASAN — Fri, 09 Mar 2012 10:49:48 GMT

Hi,

If you want this to be done in load script try like this

Load

Date,

Count(Distinct CustomerID) as [# of Customers]

Resident tablename Group by Date.

Celambarasan

Re: Comulate Customers

CELAMBARASAN — Fri, 09 Mar 2012 10:51:36 GMT

Hi,

If you need to do it in chart

Use Date as Dimension.

Count(Distinct CustomerID) as Expression.

Celambarasan

Re: Comulate Customers

jagan — Fri, 09 Mar 2012 11:05:27 GMT

Hi,

Check the attachment for solution.

Regards,

Jagan.

Comulate Customers

Fri, 09 Mar 2012 11:28:47 GMT

If I use simply Count(Distinct CustomerID) I get how many customers bought a product day by day. But I need how many customers bought the product until today.

(We started to sell a product 7 days ago. First day 3 customers have purchased, second day 4 customers have purchased, third day 5 or more customers purchased...)

I need something like this...

I really hope that I was clear.

Thanks

Comulate Customers

CELAMBARASAN — Fri, 09 Mar 2012 11:35:40 GMT

Hi,

Try with this expression

Expression label:[Count of Customers]

=RangeSum(Count(Distinct CustomerID),Above([Count of Customers]))

Celambarasan

Re: Comulate Customers

jagan — Fri, 09 Mar 2012 11:58:31 GMT

Hi,

Check the attached file for solution.

Regards,

jagan.

Comulate Customers

Fri, 09 Mar 2012 12:02:21 GMT

Hi,

It is same as COUNT(Distinct CustomerId) with full accumulation.

This is not what Im looking for.

Sorry.

Anybody has a different idea?

Thanks

Comulate Customers

jagan — Fri, 09 Mar 2012 12:04:26 GMT

Hi,

Check the above attachment for solution.

Regards,

jagan.

Comulate Customers

Fri, 09 Mar 2012 12:06:09 GMT

Thank you Jagan Mohan!

Thats it!

Its great!

Regards,