Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
MikeJones
Creator
Creator

Sort Bar Chart Legend

Hi, I wish for my bar chart legend to shw as 2025 - Jan, 2025 - Feb and 2025 - Mar and so on.

MikeJones_0-1743413142701.png

The Dimension Group is Campaign, Bars Month and Measures in Agent Contact %.

Sorting shows 1 Campaign, 2 Month, 3 Agent Contact %.

Within Sorting Month, I have sort by expression, Dual([Date.autoCalendar.YearMonth], Year([Date.autoCalendar.YearMonth])*100 + Month([Date.autoCalendar.YearMonth])), sort numerically Descending.  Sort alphabetically has not been chosen.

 

Labels (5)
2 Replies
Chanty4u
MVP
MVP

Try this 

Dual(Year([Date]) & ' - ' & MonthName([Date]), Year([Date])*100 + Month([Date]))  

 

MikeJones
Creator
Creator
Author

Hi Chanty4u, thanks for your reply.

Within the sorting section, I have tried below in the expression area for Month.

Dual(Year([QLIK_CallCentreInOutboundCalls.Date]) & ' - ' & MonthName([QLIK_CallCentreInOutboundCalls.Date]), Year([QLIK_CallCentreInOutboundCalls.Date])*100 + Month([QLIK_CallCentreInOutboundCalls.Date]))   and it's doesn't sort.