topic Count people distinct per day in QlikView

Count people distinct per day

carlos13 — Mon, 20 Jan 2014 17:29:07 GMT

I want to count the number of different people doing transactions per day.

A person can do different transactions per day, but count me as one.

the total, whether selected years, days or months count a person per day always

thought so, but it didn't work

Aggr( Count( Distinct ID_PEOPLE)) , Day)

Thanks in advance,

Re: Count people distinct per day

Anonymous — Mon, 20 Jan 2014 18:16:03 GMT

Carlos,

It looks like you need another function around your Aggr() function. Do you want the average number of distinct people per day? Or are you just trying to look at the distinct number of people per day?

If you want something like the average or overall total, you need something like:

Avg( Aggr( Count(DISTINCT ID_PEOPLE), Day) )

Sum( Aggr( Count(DISTINCT ID_PEOPLE), Day) )

If you just want to see the distinct count per day, then create a new straight table chart. Then, select Day as your dimension and use Count(DISTINCT ID_PEOPLE) as your expression.

I hope this helps. Let me know if I'm misunderstanding what you want.

-Jeff

Re: Count people distinct per day

aveeeeeee7en — Mon, 20 Jan 2014 18:42:23 GMT

Hi Chris

Please see the Attached Sample Qvw.

Hope it works.

Regards

Aviral Nag

Re: Count people distinct per day

Anonymous — Mon, 20 Jan 2014 21:15:40 GMT

Hi Carlos,

As per your requirement count the number of different people doing transactions per day.

with a person doing different transactions per day counted as one,below expression works

=Sum( Aggr( Count(DISTINCT ID_PEOPLE), Day) )

Re: Count people distinct per day

Tue, 21 Jan 2014 07:18:58 GMT

hi Carlos,

I think you want to avoid the selection of year, month and date. then you have to use the set analysis like this.

Aggr( {$<YEAR=,MONTH=,Day=>} ( Distinct ID_PEOPLE))