Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Fiscal week variable of today (fiscal year starts feb 1st)

Hi Community,

Just wondering if there were some creative minds.  I'm trying to figure out a way that wont break every year for having a variable that is for the current fiscal week.  If our fiscal year was jan 1 it would be easy with week(today()).  Our fiscal year starts feb 1 though and ive just tried adding days and such but it doesn't seem very robust.  Any ideas?

1 Solution

Accepted Solutions
Not applicable

Re: Fiscal week variable of today (fiscal year starts feb 1st)

I solved it but you have to load it in the script with your dates table

if("DATES_ISO_DATE"=today(),"DATES_FISCAL_WEEK")as "Current Fiscal Week Flag",

2 Replies
Not applicable

Re: Fiscal week variable of today (fiscal year starts feb 1st)

I have an Iso Dates field that is the same format as today() and was trying something like the following:

=if(today()=DATES_ISO_DATE, FW) but it doesn't work. 

Not applicable

Re: Fiscal week variable of today (fiscal year starts feb 1st)

I solved it but you have to load it in the script with your dates table

if("DATES_ISO_DATE"=today(),"DATES_FISCAL_WEEK")as "Current Fiscal Week Flag",

Community Browser