topic Re: Counting aggregate sums in QlikView

Counting aggregate sums

asalamun — Sat, 16 Nov 2024 03:20:58 GMT

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.

Re: Counting aggregate sums

lironbaram — Mon, 10 Jun 2019 13:13:40 GMT

should be something like

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

Re: Counting aggregate sums

asalamun — Mon, 10 Jun 2019 13:39:29 GMT

That doesn't seem to work,

These are the results it gives me.

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

Re: Counting aggregate sums

lironbaram — Mon, 10 Jun 2019 14:07:17 GMT

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

can you share sample data?

Re: Counting aggregate sums

Brett_Bleess — Thu, 11 Jul 2019 21:19:37 GMT

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