Week number

[Aspiring_Developer]

hello all,

Request you to please help me with below scenario :-

In my Data , i have Date field which has data commencing from 2018. From This date i created week numbers:-

Week(Date_Test) as Week_test

For a particular selection i get the below data :-

Here my Date range is August 2,2021  to August ,8 , 2021  which is ideally week number 31.

However in my case it is coming week number 32. My week numbers are not coming in correct order. 

I don't know how to proceed with as i am stuck. Can anyone please help me ?

Thanks in advance.

[brunobertels · Accepted solution]

Hi 

week functin get some parameters to control the result as fisrtdayofweek, brokenweek 

see below :

if you put 0 as brokenweek ( second parameters ) it's give you Week 31 , putting 1 as brokenweeks parameters will give 32 

in your case you should write 

Week(Date_Test,0,0) as Week_test

chek also that main variable for brokenweek is set to 0 

SET BrokenWeeks=0;

see help menu :

https://help.qlik.com/en-US/sense/May2021/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFunc... 

hope it helps