Discussion board where members can get started with QlikView.
Assuming I have the following table:
I need an Aggr formula that would produce a virtual table that's something like this:
The output table of the Aggr formula takes all activity_IDs that have different Time Periods and ActivityType_IDs and keeps the Dates correlated
How about this
Sum(Aggr(Percentage, Date, ActivityType_ID, Time Period))
View solution in original post
What is the end goal that you are trying to achieve here?
Do a Sum on the Percentage field of the aggr table
That's it! Thank you!