Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

suryaa30
Contributor II

Finding WeekNo -Feb as Year Starting and Sunday as weekstart

Hi

I have to find week no from given Invoice date.

Feb is the year start

Sunday is the week start

Div((Invoice_Date-YearStart(Invoice_Date,0,2)-WeekDay(YearStart(Invoice_Date))+3),7)+1

Any help is appreciated. Thanks

Date.JPG

6 Replies
thiago_justen
Valued Contributor III

Re: Finding WeekNo -Feb as Year Starting and Sunday as weekstart

Surya,

I'm not sure if I'm missing anything but: Why don't you use Week() function?

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
suryaa30
Contributor II

Re: Finding WeekNo -Feb as Year Starting and Sunday as weekstart

Week takes Jan as reference.

I want my weekno to start from Feb of every year.

thiago_justen
Valued Contributor III

Re: Finding WeekNo -Feb as Year Starting and Sunday as weekstart

So, please try this out:

Week(YOUR_DATE_FIELD,6,0,31)

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
suryaa30
Contributor II

Re: Finding WeekNo -Feb as Year Starting and Sunday as weekstart

I am somewhere close to the requirement with this, but still looking for other options

Week(YOUR_DATE_FIELD,6,0,31)-1


Thanks Much

brunobertels
Valued Contributor

Re: Finding WeekNo -Feb as Year Starting and Sunday as weekstart

thiago_justen
Valued Contributor III

Re: Finding WeekNo -Feb as Year Starting and Sunday as weekstart

Hey Surya,

Any news about it? If this thread is solved, please let us know by marking the correct answer.

Cheers

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
Community Browser