topic Sorting Buckets ? in QlikView

Sorting Buckets ?

Fri, 10 Oct 2014 14:40:06 GMT

Hi All,

0-3 Months, 3-6 Months, 6-9 Months, 9-12 Months,1-2 Years,2-3 Years..

all are coming Randomly..I need to sort ?

Regards,

Helen

Fri, 10 Oct 2014 14:44:35 GMT

HI Helen,

You can use Dual(BucketField,BucketsortOrder) inside the script to achive what you want.

For example Dual(0-3 Months,1)....Dual(2-3 Years,5)

JonnyPoole — Fri, 10 Oct 2014 14:45:11 GMT

Hit the Sort tab and only check expression, select 'ascending', and enter an expression that will do this for you.For these values

Maybe something like

if( right( [Field], 6) = 'Months', left([Field],1)*1 , left([Field],1) *100)

They will be sorted as follows:

Value Sort order

0-3 Months 0

3-6 Months 3

6-9 Months 6

9-12 Months 8

1-2 Years 100

2-3 Years.. 200

it will work but its just one quick way. Otherwise you can build a bigger IF statement or a load a mapping table