topic Re: Week number Impact in QlikView

Week number Impact

manoranjan_d — Mon, 13 Jun 2016 10:02:23 GMT

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

Re: Week number Impact

swuehl — Mon, 13 Jun 2016 10:05:27 GMT

Have a look at

Redefining the Week Start

Redefining the Week Numbers

Redefining the Week Start in Qlik Sense

Re: Week number Impact

Mark_Little — Mon, 13 Jun 2016 10:06:55 GMT

Read the below

Redefining the Week Numbers

Redefining the Week Start in Qlik Sense

Mark

Re: Week number Impact

manoranjan_d — Mon, 13 Jun 2016 10:48:01 GMT

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.

Re: Week number Impact

Mark_Little — Mon, 13 Jun 2016 10:54:32 GMT

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

Re: Week number Impact

manoranjan_d — Mon, 13 Jun 2016 11:38:15 GMT

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