Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
gauravgg
Partner - Creator
Partner - Creator

FY Calendar , how to get Week 1,2,3,4.. in every month?

Hi all

I have a FY Calendar , in which i have create following field

if(

     Weekstart(Date,0,0)=weekstart(yearstart(Date,1,4),0,0),

     1,

     Div(Date-YearStart(Date,0,4) + WeekDay(YearStart(Date,0,4),0) +7,7)

)  as FiscalWeek

which gives me FY week  like 1,2,3,4,5,.......53

But my requirement is for every month their should be W1,W2,W3,W4 ,W5 for every month .

can anyone help me in this

Thanks in advance

5 Replies
pradosh_thakur
Master II
Master II

'W'&Ceil(Day(Date)/7) as  MonthlyWeek

or

try replacing yearstart with monthstart

Learning never stops.
gauravgg
Partner - Creator
Partner - Creator
Author

Hi pradosh , thanks for reply .

But it is not working 

pradosh_thakur
Master II
Master II

'W'&Ceil(Day(Date)/7) as  MonthlyWeek working perfectly fine for me .. what format is [Date] Field in?

Learning never stops.
MK9885
Master II
Master II

'W' & Week(Date)    as WeekNumber,

That should give you w1,w2,w3 etc

Untitled.png

rawee
Contributor
Contributor

Load

Week(date_use)-Week(MakeDate(Year(date_use),Month(date_use),1))+1 AS "Week"

Resident table;