Within Qlik Sense dashboard, I've created a bar chart of gender/age breakdown. However, the automatic sorting of the age categories is in the wrong order. So I'm using a sorting expression to put these in the correct order. However, the order of the items in the bar chart is still in the incorrect order. What am I doing wrong??
Here's the sorting expression I'm using:
Match([FemaleAge],
'Female (>50)',
'Female (18-50)',
'Female (5-18)',
'Female (1-5)' and
'Female baby')
Any ideas?
