Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ioannagr
Creator III
Creator III

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
shiveshsingh
Master
Master

can you try this?

 

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

View solution in original post

4 Replies
sunny_talwar

May you need an outer aggregation? Try using Sum

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

can you try this?

 

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

ioannagr
Creator III
Creator III
Author

Hello Sunny, 

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

Enlighten me on this please

sunny_talwar

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...