Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
asalamun
New Contributor

Counting aggregate sums

I have a list of requests and each one includes the user id, I'm trying to create a bar chart to show the number of users that have made 4 or more requests in a given monthYear.

I already have the month year field from Master calendar, but I'm just having trouble getting the sum of counts.

 

Labels (5)
4 Replies
Partner
Partner

Re: Counting aggregate sums

hi 

should be something like 

sum(aggr(if (count(RequestID)>3,1,0),userId,monthYear))

asalamun
New Contributor

Re: Counting aggregate sums

That doesn't seem to work, 

These are the results it gives me.

snip1.PNG

But the numbers should be like this

Jan-2019                0

Feb-2019                3

Mar-2019                4

Apr-2019                 4 

May-2019                4

Jun-2019                 0

 

Partner
Partner

Re: Counting aggregate sums

hi

it's hard to know the problem , with out data

can you share sample data?

Support
Support

Re: Counting aggregate sums

Not sure if you sorted things out or not, so just in case not, and you cannot post any data, I wanted to drop the following Design Blog link out here for you, there are some additional links at the bottom of the post, just FYI, hopefully this will get you what you need if you are still struggling.

https://community.qlik.com/t5/Qlik-Design-Blog/Pitfalls-of-the-Aggr-function/ba-p/1463275

Regards,
Brett

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.