Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I wish for my bar chart legend to shw as 2025 - Jan, 2025 - Feb and 2025 - Mar and so on.
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.
Try this
Dual(Year([Date]) & ' - ' & MonthName([Date]), Year([Date])*100 + Month([Date]))
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.