Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
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"
I tried this approach, it worked.
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!
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]