Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
chrisellis
Contributor

Ordering Weeks QlikSense

I am using the following syntax to order the month because we run from September to September

Match([Month Field],'Sep','Oct','Nov','Dec','Jan','Feb','Mar','Apr','May','Jun','Jul','Aug')

I am creating the week number using the following syntax

Right(WeekName(DATE(Date#(Date,'DD MMMM YYYY'))),2) As "Week"

I want to do the same with the week number by starting at month 9 or week 36.

Is there a better way of ordering the week number than the way I have ordered the month ?

Any help appreciated.

Chris

Tags (1)
1 Reply
bwisealiahmad
Valued Contributor

Re: Ordering Weeks QlikSense

Do you have a master calendar implemented?

You actually have a Week() function that will give you the week number of the date which I would look into if I was you. Maybe a combination of a Week-Year Field.