Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mihai_iov
Creator II
Creator 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

1 Solution

Accepted Solutions
sunny_talwar

How about this

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

View solution in original post

4 Replies
sunny_talwar

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

mihai_iov
Creator II
Creator II
Author

Do a Sum on the Percentage field of the aggr table

sunny_talwar

How about this

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

mihai_iov
Creator II
Creator II
Author

That's it! Thank you!