Year to Date question

hobanwashburne — Mon, 10 Nov 2014 15:30:31 GMT

The majority of my apps run off the same master calendar which uses Boolean variables for "Current Fiscal Year to Date" and "Last Fiscal Year to Date".

To arrive at those values I first calculate a Fiscal date from the current date:

date(addmonths(($(vMinDate) + RowNo() - 1, -3)) as FiscalDate

Then I use the function

InYearToDate(FiscalDate, AddMonths($(vToday), -3), 0) * -1 as CurrentFiscalYearToDate

InYearToDate(FiscalDate, AddMonths($(vToday), -3), -1) * -1 as LastFiscalYearToDate

This works well, however now I need to use Fiscal Year as a dimension so I need a "Fiscal Year to Date" flag that is regardless of year. My set analysis needs to change from:

{< CurrentFiscalYearToDate = {1} >}

to:

{< FiscalYearToDate = {1}, FiscalYear = {2014} >}

topic Year to Date question in QlikView

Year to Date question