Week number Impact

[manoranjan_d]

Hi,

Backend oracle which reads the week from sunday to saturday , but my qlikview reads the week from monday to sunday.

And then i applied the week function in the date to get the week number in qlikview,

Now my qlikview week number and backend oracle weeknumber are getting differ.

pls help me how to solve this impact to matched week number

[swuehl]

Have a look at

Redefining the Week Start

Redefining the Week Numbers

Redefining the Week Start in Qlik Sense

[Mark_Little]

Hi

Read the below

Redefining the Week Numbers

Redefining the Week Start in Qlik Sense

Mark

[manoranjan_d]

i m not using the master calendar in qlikview ,since all  calendar calculation and creations are done in backend itself, i m just simply calling the qvds in qlik view, so can i implement the week number in my qlikview script.

[Mark_Little]

Hi,

Ok, You will need to have a look doing an if statement on load.

Something like

IF(WEEKDAY(Date) = 'Sun', WEEK(Date) -1, WEEK) AS WeekNo,

also you will need to catch the start and end weeks slightly different

Mark

[manoranjan_d]

this is the field i m converting to week number, how can i implement it,

week(Date(created_date,'MMDDYYYY')) as WeekNumber,with your scenario