Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Count Distinct X Over Time

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

4 Replies
abeyphilip
Contributor II

Re: Count Distinct X Over Time

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

Try

Aggr(COUNT(Distinct Customer), WeekNumber)

Not applicable

Re: Count Distinct X Over Time

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

abeyphilip
Contributor II

Re: Count Distinct X Over Time

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

Community Browser