Discussion board where members can get started with Qlik Sense.
I have create Month as 'Year(event_start_time)&'-'& Month (event_start_time)as Month'.
The result will be like '2018-sep'
When i used it as x-axes dimension in a graph the order is not correct.
How can I solve this?
Sorting -> Sort by Expression
Include -> [event_start_time.autoCalendar.MonthRelNo]
May be create the dimension like this
Date(MonthStart(event_start_time), 'YYYY-MMM') as Month
When using this expression the dateformat is like this: '2018-09-01', not '2018--sep''
I found the solution.
Use 'Max(event_start_time)' as sort expression