Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
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.
stekol61
Contributor

Sort Year-Week in graph

Hi!

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 "

stekol61
Contributor

Re: Sort Year-Week in graph

This solved my problem

Thank You

Community Browser