If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I'm using an age band as below:
If(age > 0 and age < 20, ('Under 20'),
If(age >= 20 and age < 30, ('20-30'),
If(age >= 30 and age < 40, ('30-40'),
If(age >= 40 and age < 50, ('40-50'),
If(age>= 50 and age < 60, ('50-60'),
If(age >= 60 and age < 70, ('60-70'),
If(age >= 70, ('70 & Over') ))))))) as Age Band
but I wish to automatically sort them so 'Under 20' is first on any list/sheet/table produced and not last. I have tried to use dual() but I cannot get it to work. Any help would be appreciated.
Use a dual field to order a string by a number, for example:
Dual('Under 20', 20)
And I would recommend to have a look at the Class() function, maybe is useful for you.
View solution in original post
Brilliant, Thank you