Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Ridone_2891
Contributor
Contributor

How to create Bucket

Hi, 

Can any one suggest how to create bucket of the following belew data..

Question : Create the following buckets for Discount:

    0-0.05

    0.06-0.1

    0.1-0.15

    0.16-0.25

 

   

Labels (1)
2 Replies
prma7799
Master III
Master III

Anil_Babu_Samineni

Since this is based on discount, Use like

If(discount>=0 and discount<=0.05, '0-0.05', If(discount>=0.06 and discount<=0.1, '0.06-0.1', If(discount>0.1 and discount<=0.15, '0.1-0.15', If(discount>=0.16 and discount<=0.25, '0.16-0.25')))) as Discount_Bucket

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful