topic Re: Count Distinct X Over Time in QlikView

Count Distinct X Over Time

Mon, 30 Sep 2013 14:51:25 GMT

I've got a expression I'm struggling with...so pose to the QV experts.

The Bars on the combo below is a simple expression and works fine.

=Count(Distinct Customer)

But want the line to show the unique customer count by week. But QV is incorrectly summing it up to 117 (Image002), where it should be 37 (Image003). I've played around with the Aggr() funciton, but unable to crack it.

Help

Jay

Re: Count Distinct X Over Time

abeyphilip — Mon, 30 Sep 2013 15:33:16 GMT

Hi Jay,

Seems to be the "full Accumulation" option is enabled on the expression for customer count.

Please check - Expressions -> Accumulation value set for Customer count.

For separate weekly count, you will have to set "No Accumulation"

Regards,

Abey

Re: Count Distinct X Over Time

MK_QSL — Mon, 30 Sep 2013 16:00:40 GMT

Try

Aggr(COUNT(Distinct Customer), WeekNumber)

Re: Count Distinct X Over Time

Mon, 30 Sep 2013 16:05:17 GMT

Thanks for the quick response – Accumulation is already set to 'No Accumulation'

Re: Count Distinct X Over Time

abeyphilip — Mon, 30 Sep 2013 20:14:15 GMT

Hi,

I hope you have checked this setting specifically for the "line graph" expression in question.

Can you please recreate this problem with a sample set of data and post the qvw?

Regards,

Abey