Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Sort YYYY-MM in graph

Hi!

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?

Graph date.PNG

4 Replies
Partner
Partner

Re: Sort YYYY-MM in graph

Try below

Sorting -> Sort by Expression

Include -> [event_start_time.autoCalendar.MonthRelNo]

Highlighted

Re: Sort YYYY-MM in graph

May be create the dimension like this

Date(MonthStart(event_start_time), 'YYYY-MMM') as Month

Highlighted
Creator
Creator

Re: Sort YYYY-MM in graph

Hi!

When using this expression the dateformat is like this: '2018-09-01', not '2018--sep''

Date(MonthStart(event_start_time), 'YYYY-MMM') as Month



Highlighted
Creator
Creator

Re: Sort YYYY-MM in graph

I found the solution.

Use 'Max(event_start_time)' as sort expression