Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
SonOfJeffGoldblum
Contributor III
Contributor III

AGGR Help

Hello,

I need help with what seems easier than it should be. I have a bar chart that I want to display the number of speakers we have had.

Right now, we have current data for 2019 but no previous years, yet in the dataset dates are shown for previous years.

We have 10 group talks, with each talk a different topic. What shows now is only what topic you are on with no tally of having completed previous topics. There is no breaking order. Would I be using AGGR() to figure out that if I did speech 10, I also did 1-9; speech 9 I did 1-8; speech 8 I did 1-7 and so on? This would then for each person put a tick mark in each topic bucket where if 10 people completed all 10, each topic for them would also have a tick mark of those being completed.

Everything not saved will be lost
— Nintendo Quit screen message
2 Replies
Channa
Specialist III
Specialist III

you have to work with P(),E() 

union * 

Channa
SonOfJeffGoldblum
Contributor III
Contributor III
Author

Thank you Channa,

How would you write this if I may ask for an example where a tally for the current completion and all previous are placed within their own bucket?

PersonCurrent CountCompletedGoal Count
A155
B11010
C111
D122
E144
Everything not saved will be lost
— Nintendo Quit screen message