topic Re: WeekNum Function Help? in QlikView

WeekNum Function Help?

bazzaonline — Wed, 03 Jun 2015 14:33:33 GMT

Hello,

Im trying to create something in the script that translates a yyyy-mm-dd day format to give me a weeknum, ideally year then number. So yyyy-01, yyyy-02 etc etc..

Thanks Paul

Re: WeekNum Function Help?

fvelascog72 — Wed, 03 Jun 2015 14:40:25 GMT

Hi, Try this:

Year(Date)&'-'&Week(Date)

Re: WeekNum Function Help?

swuehl — Wed, 03 Jun 2015 14:42:37 GMT

Weekyear(date#(YourField,'YYYY-MM-DD'))&-&Week(date#(YourField,'YYYY-MM-DD'))

Re: WeekNum Function Help?

alexandros17 — Wed, 03 Jun 2015 14:42:48 GMT

Try with WeekYear(myDate) & '-' & Num(Week(myDate),'00')

let me know

Re: WeekNum Function Help?

Anonymous — Wed, 03 Jun 2015 14:48:54 GMT

Hi ..

This a example:

=Year(date('2015-06-01','YYYY-MM-DD'))&'-'&Week(date('2015-06-01','YYYY-MM-DD'))

output

2015-23

=Year(date(fieldDate,'YYYY-MM-DD'))&'-'&Week(date(fiedDate,'YYYY-MM-DD'))

Re: WeekNum Function Help?

bazzaonline — Wed, 03 Jun 2015 14:54:57 GMT

Brilliant, saved me a world of hassle!

Re: WeekNum Function Help?

alexandros17 — Wed, 03 Jun 2015 15:01:20 GMT

Take a look at my answer:

WeekYear takes the year in wich the week follows so it is the correct year because for some dates you could have wrong year week combinations.

Second I put Num(...) formatted with two digits '00' in this way your output will Always have the same lenght, otherways you will have

20151

20152

201511

and so on