Creating sum buckets in visulization

[naveen341]

HI Team

 I Have a table id,balance

1,1000

2,578903

3,4500

 Now i want to create bucket in a list box like

sum(balance)

0+

500+

1000+

How can i acheive this

Thanks in Advance

@rwunderlich @sunny_talwar

@marcus_sommer,@Oleg_Troyansky , @sunny_talwar,@rubenmarin ,

• @stalwar1
• @arturo muñoz
• @christof schwarz
• @gysbert wassenaargysbert
• @qlikview
• qlikview visulaizations
• sunny talwar
• @wassenaar

[ryanridley]

I would recommend using the CLASS function in your script. You will need to specify the interval to use for the buckets, but it should give you a field that you can then use in your visual.

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Condi...

[naveen341]

hi @ryanridley 

i have the balance amount for individual records but i need the filter or bucket for sum of balance amount.

how can i acheive that

[settu_periasamy]

May be try like

Load Id, if(sum(balance)>1000,'1000+',

                    if(sum(balance)>500 and sum(balance)<=1000,'500+','0+'))      as Bucket group by Id;

Load Id,balance from source;

[Brett_Bleess]

Naveen, best I have is the following, not sure if this may work or not:

https://community.qlik.com/t5/Qlik-Design-Blog/IntervalMatch/ba-p/1464547

There are some other posts in the Design Blog area, just FYI, so you may want to search yourself out there too.

Regards,
Brett