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: 
Karahs
Partner - Creator
Partner - Creator

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
sunny_talwar

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])

View solution in original post

2 Replies
sunny_talwar

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])

Karahs
Partner - Creator
Partner - Creator
Author

Thanks Sunny T , it worked (y)