Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

How can I show Week over Week analysis for two years


I have a WoW analysis of the number of requests

My dimension is:


My measure is

Request # count

The chart looks okay in 2017, but in 2018 I have a problem as the chart looks like this:

eg,number of requests.jpg

What do I want?

I want the two weeks of 2018 to be at the end of the chart not at the first

If someone can help, I'll appreciate that

6 Replies

For a dimension you will have to use a combination of year and month which would be the field:


Contributor II
Contributor II

Hi Petter and thanks for the response

Unfortunately, I don't have that dimension yet, can you help me out on how to create it in the script?

I tried this but it didn't work out


Master II
Master II


you can try to add like below,

Week(weekstart(CalDate)) & '-' & WeekYear(CalDate) as WeekYear,

after adding this field try to add in your chart - sort table expression WeekYear as ascending order and u can get the desired result

Note: remember to update your Date field instead of CalDate.



Contributor II
Contributor II

It worked and gave me the results but it shows weeks from right to left

Is there any way I can make the weeks from left to right?

Thanks a lot!

Master II
Master II


so just want the latest WeekYear to be in the left side and history week display in right side right? then u try to change the Sort order as descending




Give you the right order in an autocalender if you have

Set BrokenWeeks=0;