topic Re: Bucketing in QlikView

Bucketing

dhavalvyas — Wed, 25 Nov 2020 16:16:04 GMT

What is expression for following KPI to create bucketing ?

Bucketing of sales order 1-30 , 31-60 , 61-90, 91-120 ,121 to Above

Re: Bucketing

Frank_Hartmann — Mon, 20 Mar 2017 16:02:11 GMT

try:

=class(Field,30)

as dimension

and

count(Field)

as expression

hope this helps

Re: Bucketing

Anil_Babu_Samineni — Mon, 20 Mar 2017 16:02:43 GMT

May be this?

If(order >=1 and order <31, Dual('0-30',1), If(order >=31 and order <61, Dual('31-60',2), If(order >=61 and order <91, Dual('61-90',3), If(order >=91 and order <121, Dual('91-120',4), If(order >=121,Dual('>=121',5))))))

Re: Bucketing

sunny_talwar — Mon, 20 Mar 2017 16:03:16 GMT

Check here may be:

Buckets

Re: Bucketing

aarkay29 — Mon, 20 Mar 2017 16:07:57 GMT

Something like this

if([Days Late] <1, 'On Time',

if([Days Late] < 31 and [Days Late] > 0, '1 - 30',

if([Days Late] < 61 and [Days Late] > 30,'31 - 60',

if([Days Late] < 91 and [Days Late] > 60, '61 - 90',

if([Days Late] < 121 and [Days Late] > 90, '91 - 120',

if([Days Late] > 120, 'Over 120')))))) as [Age Bucket]