Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

aggr count issue

Hello everyone.

I want to count the distinct donation dates where the status of the donation is 0  grouped by each donor.

I wrote this :

=aggr(count(count({<donationcompleted='0'>} distinct donationdate)),[donor_id])

 

and while the expression is 'OK' i get  ' - ' everywhere.

 

What am i writing wrong?

 

Thank you in advance.

1 Solution

Accepted Solutions
Highlighted
Master
Master

can you try this?

 

=aggr(count({<donationcompleted={'0'}>} distinct donationdate),[donor_id])

View solution in original post

4 Replies
Highlighted

May you need an outer aggregation? Try using Sum

Sum(Aggr(
    Count({<donationcompleted = {'0'}>} DISTINCT donationdate)
, [donor_id]))
Highlighted
Master
Master

can you try this?

 

=aggr(count({<donationcompleted={'0'}>} distinct donationdate),[donor_id])

View solution in original post

Highlighted
Creator II
Creator II

Hello Sunny, 

won't this outer aggregation sum the id's? 

Enlighten me on this please

Highlighted

Sum the ids? Why would it sum the ids? It will sum the Count of distinct donationdate.... but if you already have found your solution... then all good...