Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor II

Sorting Expression not working

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?

Tags (1)
1 Reply
Highlighted

Re: Sorting Expression not working

May be the extra and is causing it... try this

Match([FemaleAge],

    'Female (>50)',

    'Female (18-50)',

    'Female (5-18)',

    'Female (1-5)',

    'Female baby')