Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kshitijas
New Contributor III

Buckets!

Hi everyone,

Need Following Buckets For Count(Complain) as Dimension or as a Filter pane  in Following Format :

1 - 2

More than 5

More than 7

More than 10

bucket.png

Thanks&Regards,

Kshitija

1 Solution

Accepted Solutions
MVP
MVP

Re: Buckets!

May be like this:

Aggr(

If(Count(Complain) < 2, Dual('1-2', 1),

If(Count(Complain)  > 10, Dual('More Than 10', 4),

If(Count(Complain)  > 7, Dual('More Than 7', 3),

If(Count(Complain)  > 5, Dual('More Than 5', 2))))), [Client Code])

2 Replies
MVP
MVP

Re: Buckets!

May be like this:

Aggr(

If(Count(Complain) < 2, Dual('1-2', 1),

If(Count(Complain)  > 10, Dual('More Than 10', 4),

If(Count(Complain)  > 7, Dual('More Than 7', 3),

If(Count(Complain)  > 5, Dual('More Than 5', 2))))), [Client Code])

kshitijas
New Contributor III

Re: Buckets!

Thanks Sunny T , it worked (y)

Community Browser