Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.

Sort Year-Week in graph


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?

2 Replies

Re: Sort Year-Week in graph

Try creating it like this

Dual(" Year &'-'&replace(upper(Week),'W',''), Year*100 + replace(upper(Week),'W','')) as YearWeek "


Re: Sort Year-Week in graph

This solved my problem

Thank You

Community Browser