This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a FY Calendar , in which i have create following field
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
'W'&Ceil(Day(Date)/7) as MonthlyWeek
try replacing yearstart with monthstart
Hi pradosh , thanks for reply .
But it is not working
'W'&Ceil(Day(Date)/7) as MonthlyWeek working perfectly fine for me .. what format is [Date] Field in?
'W' & Week(Date) as WeekNumber,
That should give you w1,w2,w3 etc
Week(date_use)-Week(MakeDate(Year(date_use),Month(date_use),1))+1 AS "Week"