Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a chart of events by age group, where the age group is in 5-year bands starting at '00-04','05-09' and ending at '85+'. I've set the chart to sort alphabetically.
Until recently, this worked perfectly: '00-04' on the left, and '80-84' towards the end, followed by '85+'. I have now found - is this with Qlik Sense V3.1, or did it slip in unnoticed? - that the chart starts with '85+' on the left. (It's not a reverse order, by the way.) The x-axis order, still sorted alphabetically, is '85+', '00-04', '05-09' ... up to '80-84'.
I've managed an ugly fix, using 'Over 84' instead of '85+', but I have to ask (with less urgency), doesn't 85 come after 80 in an alphabetical sort?
hi
it does seems strange
but your work around can be
sort by expression
ues the expression max(Age)
and it should be sorted right
hi
it does seems strange
but your work around can be
sort by expression
ues the expression max(Age)
and it should be sorted right
Thanks, Liron, for the quick and correct answer!