Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Required Monday to Sunday
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
Hi
Try like below
Solved: Month Week ( 1 to 4 or 5 weeks) - Qlik Community - 369625