Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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

Re: aggr count issue

can you try this?

 

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

View solution in original post

4 Replies
Highlighted

Re: aggr count issue

May you need an outer aggregation? Try using Sum

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

Re: aggr count issue

can you try this?

 

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

View solution in original post

Highlighted
Creator
Creator

Re: aggr count issue

Hello Sunny, 

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

Enlighten me on this please

Highlighted

Re: aggr count issue

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