topic Re: Creating sum buckets in visulization in QlikView

Creating sum buckets in visulization

naveen341 — Sat, 16 Nov 2024 02:28:37 GMT

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)

500+

1000+

How can i acheive this

Thanks in Advance

@rwunderlich @sunny_talwar

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

Re: Creating sum buckets in visulization

ryanridley — Mon, 16 Sep 2019 18:42:40 GMT

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/ConditionalFunctions/class.htm

Re: Creating sum buckets in visulization

naveen341 — Mon, 16 Sep 2019 18:58:30 GMT

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

Re: Creating sum buckets in visulization

settu_periasamy — Tue, 17 Sep 2019 04:29:37 GMT

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;

Re: Creating sum buckets in visulization

Brett_Bleess — Thu, 26 Sep 2019 20:34:07 GMT

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