Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Re: Date sort order in line chart

I was struggling with the same issue for a while. In my case, 'Sort' was still enabled for one or more Measures. Somehow, Sort on Measure overruled Sort on (time) Dimension. Try disabling Sort for all Measures and see if that helps.

oscarmqz
Contributor III

Re: Date sort order in line chart

Hi Dennis, thanks for the help, I'll try that next time. What I ended up doing to fix it was creating a new field with this definition in the script to remove the year:

month([Report Date])&'-'&day([Report Date]) as [Report Date 2]

And then sorted ascending by the original [Report Date] in script as well

The dimension then was only sorted by "Load order"

Regards,

Oscar

vikraant
Contributor

Re: Date sort order in line chart

I tried this approach, it worked.

Thanks !

anishphilljoe
New Contributor II

Re: Date sort order in line chart

Hi Travis, I was facing similar issue and this solved it. I set the dimension to the recommended expression and sorted the dimension alphabetically. Thanks!

Highlighted
james_butler
New Contributor III

Re: Date sort order in line chart

I encountered a similar problem when combining a period and year.

Using Date#() in the script worked.

I couldn't sort a chart correctly with:

Period & '-' & "Year" as [Period Year]

but this worked

Date#(Period & '-' & "Year",'MM-YYYY') as [Period Year]