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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.