Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
naveen341
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
ryanridley
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...

 

naveen341
Creator
Creator
Author

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
Master III
Master III

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
Former Employee
Former Employee

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.