Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
suryaa30
Creator II
Creator 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_

Surya,

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

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago
suryaa30
Creator II
Creator II
Author

Week takes Jan as reference.

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

Thiago_Justen_

So, please try this out:

Week(YOUR_DATE_FIELD,6,0,31)

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago
suryaa30
Creator II
Creator II
Author

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
Master
Master

Thiago_Justen_

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
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago