topic Re: create a bucket function in QlikView

create a bucket function

Wed, 25 Nov 2020 16:16:04 GMT

hi i have years of experience and employees can any one help me in creating a bucket function so that i can put it like 0-10 years then 10-20, 20-30, 30-40. on a block chart

Re: create a bucket function

sunny_talwar — Thu, 09 Jun 2016 10:14:55 GMT

May be create a field in the script or create it as a calculated dimension:

If(YearExperience < 10, Dual('0-10', 1),

If(YearExperience < 20, Dual('10-20', 2),

If(YearExperience < 30, Dual('20-30', 3),

If(YearExperience < 40, Dual('30-40', 4))))

Re: create a bucket function

Thu, 09 Jun 2016 11:54:12 GMT

hi sunny but its not working

Re: create a bucket function

sunny_talwar — Thu, 09 Jun 2016 12:04:19 GMT

Where are you doing this? Script or calculated dimension? Can you share a sample where it isn't working?

Re: create a bucket function

Thu, 09 Jun 2016 12:18:51 GMT

i am doing on calculated dimensions

Re: create a bucket function

sunny_talwar — Thu, 09 Jun 2016 13:28:19 GMT

Can you share the expression you are using?

Re: create a bucket function

ziadm — Thu, 09 Jun 2016 22:57:24 GMT

use Class function

let vWidth = 10 ;

=dual(replace(Class(Age,$(vWidth)),'<= x <','to'),Class(Age,$(vWidth)))

Re: create a bucket function

pho3nix90 — Fri, 10 Jun 2016 08:34:58 GMT

Ziads code would be the better solution. However if you are using it straight in a chart do

=dual(replace(Class(Age,10),'<= x <','to'),Class(Age,10))