topic Re: Months not sorting in Line Chart in QlikView

Months not sorting in Line Chart

ZoeM — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community.

Several of my charts that are using months (Jan - Dec) as x-axis are not sorting as they should, all the charts are pulling Nov and Dec as starting months followed by Jan through Oct. This is a weird little scenario and I have tried going back to older versions of the dashboard but so much has changed from previous versions that it would be more worthwhile to try and figure out what it is.

No changes were made to the Master Calendar so not sure why this would be happening. Sorting under Chart Properties does not affect it. Im just dumb founded.

Has anybody experienced this and what kind of solutions have you found?

Thanks.

Re: Months not sorting in Line Chart

vishsaggi — Wed, 18 Jul 2018 20:40:49 GMT

Do you have a date field in your calendar?

Re: Months not sorting in Line Chart

ZoeM — Wed, 18 Jul 2018 21:50:48 GMT

Yes I do.

Charts where I am using YearMonth as a dimension have no issue.

Charts where I am using Month as Abbreviated Name and Year are not sorting as desired.

All these fields are coming through the Master Calendar and Date bridge

Re: Months not sorting in Line Chart

qlikviewwizard — Wed, 18 Jul 2018 23:03:24 GMT

Disable other Dimension's sort and do sort on YearMonth like below.

Re: Months not sorting in Line Chart

ZoeM — Thu, 19 Jul 2018 13:06:24 GMT

Hi Arjun.

I tried that too and my order is still Nov, Dec, Jan, Feb...Oct.

Re: Months not sorting in Line Chart

ZoeM — Thu, 19 Jul 2018 13:12:37 GMT

I have found a workaround where I force the chart to sort by using an expression, weird that before I never had to do that and I do not like the fact that this is a temporal fix. I still do not understand why it stopped recognizing my date fields as dates.

Match([Month of Year Abbreviated Name],'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

Re: Months not sorting in Line Chart

Anil_Babu_Samineni — Thu, 19 Jul 2018 13:28:52 GMT

Instead create field in script and enable expression from sort tab and use Month_Num instead of static

Num(Month(Date#([Month of Year Abbreviated Name],'MMM'))) as Month_Num

Re: Months not sorting in Line Chart

ZoeM — Thu, 19 Jul 2018 14:05:56 GMT

Do you mean creating this in the Master Calendar?

The Main Script is ever evolving because we are adding additional data points to our dashboard and so I do not think it would be of benefit to add it in Script?

Re: Months not sorting in Line Chart

vishsaggi — Thu, 19 Jul 2018 14:10:21 GMT

Or you can simply use below in your sort tab - Expression

= Min({1}MonthName(YourDateField))

Re: Months not sorting in Line Chart

Qlik1_User1 — Thu, 19 Jan 2023 08:53:28 GMT

@vishsaggi Can you please help what this expression will do
Min({1}MonthName(YourDateField))