Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Read about Qlik’s Response to COVID-19 Read the Letter, Join the Group.
Contributor II

Help with an aggr

Assuming I have the following table:

Activity_IDDateActivityType_IDTime PeriodPercentage
102-04-2018610-140.5
202-04-2018610-140.5
302-04-2018914-160.25
403-04-2018610-140.5
503-04-20181114-180.5
604-04-2018610-140.5
704-04-2018610-140.5
804-04-2018610-140.5
904-04-2018610-140.5
1004-04-2018610-140.5
1104-04-2018614-180.5
1204-04-2018614-180.5

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

Activity_IDDateActivityType_IDTime PeriodPercentage
102-04-2018610-140.5
302-04-2018910-140.25
403-04-2018610-140.5
503-04-20181114-180.5
604-04-2018610-140.5
1104-04-2018614-180.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

Tags (1)
1 Solution

Accepted Solutions
Highlighted

Re: Help with an aggr

How about this

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

View solution in original post

4 Replies
Highlighted

Re: Help with an aggr

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

Highlighted
Contributor II

Re: Help with an aggr

Do a Sum on the Percentage field of the aggr table

Highlighted

Re: Help with an aggr

How about this

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

View solution in original post

Highlighted
Contributor II

Re: Help with an aggr

That's it! Thank you!