#14 Creating buckets in Qlik Sense
Create Buckets in your charts for powerfull analysis
As shown in the video, creating bucket start for simple to complex analysis. It can simplifies data vizualisation or let you show a measure on a new perspective.
Calculating Buckets in Chart is mandatory for commun use cases.
Want to know how many customer purchased more then 10 products ? Classify pending invoices by total amount ?
Some basic ingredient used in the video are Class(), Aggr(), $() 🧙
Are you using Buckets in your Dataviz ? What are the main business use cases for this feature ?
❓How To❓
👨🎓 Basic Class() takes up to 4 parameters :
=Class(Age, // expression from witch you create the bucket
5, // size of the bucket
'years', // Label
18) // starting at
👨💼 Advanced one to create from the measure :
Note that the fourth parameter is optional.
=Class(
aggr(sum(MonthlyIncome),EmployeeNumber)
,3000
,'€')
👨🎨 Take it to next level by choosing how many buckets you want
3 and 4 parameters are results of expression within $()
=Class(
aggr(sum(MonthlyIncome),EmployeeNumber)
,
$(=ceil((Max(aggr(sum(MonthlyIncome),EmployeeNumber))-
Min(aggr(sum(MonthlyIncome),EmployeeNumber)))/4,100))
,'€',
$(=Min(aggr(sum(MonthlyIncome),EmployeeNumber)))
