New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for
Did you mean:  Creator

Bucket Creation In List Box

Hi all,

I need to create a bucket on the cumulative sum of percentage like in E column  like 1st quartile,

2nd quartile and third and so on ...

Can any one help me in this ....its super urgent

pfa the attached file

1 Solution

Accepted Solutions  MVP

Try this

=Aggr(
If(Alt(Above(RangeSum(Above(Sum({1}Value)/Sum(TOTAL {1} Value), 0, RowNo()))), 0) < 0.25, 'Q1',
If(Above(RangeSum(Above(Sum({1}Value)/Sum(TOTAL {1} Value), 0, RowNo()))) < 0.5, 'Q2',
If(Above(RangeSum(Above(Sum({1}Value)/Sum(TOTAL {1} Value), 0, RowNo()))) < 0.75, 'Q3', 'Q4')))
, (Prodcut, (=Sum({1} Value), DESC)))
6 Replies  MVP

Is this needed in the script?  Creator
Author

yes or even a calculated dimension will be enough to display in chart  MVP

So, you want column E in a list box? What exactly are you going to do with this? Make selection in 4% to select row 8 to 13? Is this percentage need to stay static? Meaning stay the same based on any selection within the dashboard? or do these change based on other field selection?  Creator
Author

its need to remain static....but based to cumulative percentage in E column

1-24- 1st quartile

25-50 2nd quartile

51-75 3r so on i need to create 4 buckets  MVP

Try this

=Aggr(
If(Alt(Above(RangeSum(Above(Sum({1}Value)/Sum(TOTAL {1} Value), 0, RowNo()))), 0) < 0.25, 'Q1',
If(Above(RangeSum(Above(Sum({1}Value)/Sum(TOTAL {1} Value), 0, RowNo()))) < 0.5, 'Q2',
If(Above(RangeSum(Above(Sum({1}Value)/Sum(TOTAL {1} Value), 0, RowNo()))) < 0.75, 'Q3', 'Q4')))
, (Prodcut, (=Sum({1} Value), DESC)))  Creator
Author

you are genius Tags
Community Browser