Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

How do I get an average from a Count Distinct?

I need to get the average for this expression, but it gives me an error that nested aggregation is not allowed:

=COUNT(DISTINCT([Driver ID]))

How can I get the average for this?

19 Replies
Highlighted

What dimensions are involved here?

Highlighted
Creator II
Creator II

Just Month

Highlighted

May be this

Avg(Aggr(Count(DISTINCT  [Driver ID]), Month))

Highlighted
Creator II
Creator II

That's not returning the expected result.  It's much lower than it should be.

Highlighted

I don't think you have provided enough information to help you with a solution. You need to provide more details

Highlighted
Creator II
Creator II

I think the issue is that there is another dimension in a sense.  I don't have it specified in the expression, but Vendor is needs to be accounted for as well as Month.  I have 2 values for Vendor, VendorA and VendorB.

Highlighted

Hahahaha then try to add it and check if that works or not.

Highlighted
Creator II
Creator II

Can it be done using Set Analysis?

Highlighted

I don't even know what you have and what you are trying to do... how can I say if set analysis will work or not.

If you don't mind me asking, why are you so vague with your description? Why is there a fear to share a sample