Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
markgraham123
Contributor II

Fiscal Month

Hi all,

I'm trying to generate Fiscal month based on Fiscal week.

1.     check monday of every week  - give the month number of monday's date -1  as fiscal month for the date

Can someone please help?

Any help is highly appreciated.

Tags (1)
1 Reply
MVP
MVP

Re: Fiscal Month

"give the month number of monday's date -1 "

Do you want to actually the month number of Sunday (Month(Monday's date -1)), or do you want to range your month numbers from 0 to 11 ((month number of Monday's date)-1) ?

Maybe like this (assuming weekstart is defined as Monday):

Month( WeekStart( DateField) -1) AS MonthField

or

Month(WeekStart(DateField))-1 AS MonthField

Community Browser