Creating a calculated Bucket for stacked bar chart
I am a bit of a newby to Qlikview and think I have biten off more than I can chew.
I have a table
where 1 = retained and 0 - not retained
what I want to do is create create buckets of the % retained for each course ie =Sum (retained)/Sum (Enrolled)
so I had say, 1 bucket for courses retaining over 50%, over 75% and 0ver 90%
Everything I have tried so far has failed spectacularly, so won't embarrass myself by showing my workings. I have looked through some previous discussions and can see how to create a bucet in the load script but cant figure out how to populate it with calculations
any help anyone could provide would be hugely appreciated