How to broken week 1 to week 4 every month

[Subbu55]

Hi all,

I am new to qlik sense.

My requirement is I want show week 1 to week 4 every month.

January - week 1 to week 4

February - week 1 to week 4

Need every month

Thanks in advance .

Regards,

Subba 

[Subbu55]

Required  Monday to Sunday 

[salonicdk28]

Try this-

if((week(Date(Datefield),0,0,1) - week(monthstart(Date(Datefield)),0,0,1) + 1)<1,'Week'&' '&1,
'Week'&' '&(week(Date(Datefield),0,0,1) - week(monthstart(Date(Datefield)),0,0,1) + 1)) as WeekNumber

Thanks,

Saloni

[MayilVahanan]

Hi

Try like below

Solved: Month Week ( 1 to 4 or 5 weeks) - Qlik Community - 369625