Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Displaying Rolling Last 12 Months in Order in Bar Chart

I'm trying to get a bar chart to display the rolling last 12 months in order.

My count is case code's where the start date is in the last 12 months.

My dimension is a calculated one of [start month] & [start year] which are calculated at script level as month([start date]) & year([Start date]).

I've tried sorting it in different ways but can't get it to sort in order. Any help would be greatly appreciated.

1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

Use the following expression instead:

=Date(MonthStart(Start),'MMM YYYY')

Preferably this should be added in the script, but it works fine as calculated dimension also.

/HIC

View solution in original post

1 Reply
hic
Former Employee
Former Employee

Use the following expression instead:

=Date(MonthStart(Start),'MMM YYYY')

Preferably this should be added in the script, but it works fine as calculated dimension also.

/HIC