Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a report where data is presented in a graph.
The time dimention in the graph shows Year-Week, e,g "2017-35".
This dimention is created in the loading script as " Year &'-'&replace(upper(Week),'W','') as YearWeek "
The problem is that the sorting of 'YearWeek' is not correct as you see in the graph below.
How can this be solved?
Try creating it like this
Dual(" Year &'-'&replace(upper(Week),'W',''), Year*100 + replace(upper(Week),'W','')) as YearWeek "
This solved my problem