topic Re: Age bucket sorting in QlikView

Age bucket sorting

ajsjoshua — Wed, 25 Nov 2020 16:16:04 GMT

Dear all,

I am using this in script for age bucket

If(Age <=10, '<10 Years',

IF(Age >= 11 and Age < 20, '11 - 20',

IF(Age >= 21 and Age < 30, '21 - 30',

IF(Age >= 31 and Age < 40, '31 - 40',

IF(Age >= 41 and Age < 50, '41 - 50',

IF(Age >= 51 and Age < 60, '51 - 60',

IF(Age >= 61 and Age < 70, '61 - 70',

IF(Age >= 71 and Age < 80, '71 - 80',

IF(Age >= 81 and Age < 90, '81 - 90',

IF(Age >= 91 and Age < 100, '91 - 100',

'100+')))))))))) as AgeRange,

When i use this AgeRange dimension in bar chart i am not getting the dimension in proper order.I want to sort like this

<10 Years,'11 - 20','21 - 30','31 - 40','41 - 50','51 - 60','61 - 70','71 - 80','81 - 90','91 - 100', '100+'

PFA for screenshot

sunny_talwar — Tue, 23 Jan 2018 16:57:28 GMT

Try this

If(Age <=10, Dual('<10 Years', 1),

IF(Age >= 11 and Age < 20, Dual('11 - 20', 2),

IF(Age >= 21 and Age < 30, Dual('21 - 30', 3),

IF(Age >= 31 and Age < 40, Dual('31 - 40', 4),

IF(Age >= 41 and Age < 50, Dual('41 - 50', 5),

IF(Age >= 51 and Age < 60, Dual('51 - 60', 6),

IF(Age >= 61 and Age < 70, Dual('61 - 70', 7),

IF(Age >= 71 and Age < 80, Dual('71 - 80', 8),

IF(Age >= 81 and Age < 90, Dual('81 - 90', 9),

IF(Age >= 91 and Age < 100, Dual('91 - 100', 10),

Dual('100+', 11))))))))))) as AgeRange,

Anil_Babu_Samineni — Tue, 23 Jan 2018 16:58:38 GMT

Try this, add similar to all