Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Creating sum buckets in visulization

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 ,

Labels (2)
4 Replies
Highlighted
Contributor II
Contributor II

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...

 

Highlighted
Creator
Creator

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

Highlighted

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;

Highlighted
Digital Support
Digital Support

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.