Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor

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
Highlighted
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
Contributor

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
Contributor

Re: Sort YYYY-MM in graph

I found the solution.

Use 'Max(event_start_time)' as sort expression