topic Help with an aggr in QlikView

Help with an aggr

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Assuming I have the following table:

Activity_ID	Date	ActivityType_ID	Time Period	Percentage
1	02-04-2018	6	10-14	0.5
2	02-04-2018	6	10-14	0.5
3	02-04-2018	9	14-16	0.25
4	03-04-2018	6	10-14	0.5
5	03-04-2018	11	14-18	0.5
6	04-04-2018	6	10-14	0.5
7	04-04-2018	6	10-14	0.5
8	04-04-2018	6	10-14	0.5
9	04-04-2018	6	10-14	0.5
10	04-04-2018	6	10-14	0.5
11	04-04-2018	6	14-18	0.5
12	04-04-2018	6	14-18	0.5

I need an Aggr formula that would produce a virtual table that's something like this:

Activity_ID	Date	ActivityType_ID	Time Period	Percentage
1	02-04-2018	6	10-14	0.5
3	02-04-2018	9	10-14	0.25
4	03-04-2018	6	10-14	0.5
5	03-04-2018	11	14-18	0.5
6	04-04-2018	6	10-14	0.5
11	04-04-2018	6	14-18	0.5

Further explanations:

The output table of the Aggr formula takes all activity_IDs that have different Time Periods and ActivityType_IDs and keeps the Dates correlated

sunny_talwar — Thu, 19 Apr 2018 12:36:22 GMT

What is the end goal that you are trying to achieve here?

Anonymous — Thu, 19 Apr 2018 12:38:45 GMT

Do a Sum on the Percentage field of the aggr table

sunny_talwar — Thu, 19 Apr 2018 12:40:30 GMT

How about this

Sum(Aggr(Percentage, Date, ActivityType_ID, Time Period))

Anonymous — Thu, 19 Apr 2018 12:45:21 GMT

That's it! Thank you!