Calendar Date to Fiscal Calendar Month

[Anonymous]

Hello,

I need to map my field [Purchase Date] to a fiscal period and fiscal year. I already have a common load statement that gives the following fields:

LOAD CalendarDate,

     FiscalYear,

     FiscalPeriod,

     FiscalWeek,

     cFYr_Flag,

     cFPr_Flag,

     cFWk_Flag,

     FiscalQuarter,

     cFQ_Flag,

     FiscalMonth,

     FiscalDay,

     YearStart,

     QuarterStart,

     PeriodStart,

     YearEnd,

     QuarterEnd,

     PeriodEnd,

     FiscalMonthYear,

FROM

I would like to use the PeriodStart and PeriodEnd fields to make bounds for the [Purchase Date] field in the second load. Is there a way to reference these values between the two load statements? If not, does anyone have a good way to map to fiscal month?

Thanks

[Anil_Babu_Samineni]

May be https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes...

[Anonymous]

Could you provide a more in depth example?

[Anonymous]

I found this example: QlikView Tutorials | QlikView Scirpting | QlikView IntervalMatch Function - YouTube

However, is there a way to dim this as one field?