Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please share some sample data
or please check below
https://community.qlik.com/t5/New-to-Qlik-Sense/Creating-buckets-in-Qliksense/m-p/1284632
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