Rolling 12 months for the current Financial Year

[renuka_sasikumar]

I want to show revenue Data (Month wise) for the Financial Year 2015-2016, In which The Month should be from Apr-2015 till the current month.

Can anyone help me the expression, I tried using express heading in condition as

=Month(AddMonths(vMaxDate,-1))&'-'&Year(AddMonths(vMaxDate,-1))

But I am getting Mar-2015,.....

Please find the below snapshot of my requirement

Particulars	FTD	MTD	November RR	YTD	FY	Oct-2015	Sep-2015	Aug-2015	Jul-2015	Jun-2015	May-2015	Apr-2015
Revenue	0.00	0.00	0.00	3259.39	5452.87	0.00	0.00	0.00	0.00	0.00	0.00	0.00

Regards,

Renuka S

[Anonymous]

use monthname() at script level like:

monthbname(Date) as RollingMonth.

And then at expression level..

Use calculated dimension like:

IF(RollingMonth>='April 2015', RollingMOnth)

Hope this will help

[ecolomer]

See this:

Set Analysis for Rolling Periods

https://community.qlik.com/docs/DOC-4252

[renuka_sasikumar · Accepted solution]

Hi,

I got this by adding this in my Master Calendar.

LOAD LinkCommonDate, Quarter as MonthYearQuarter

Resident Calendar_Year_2012;

Join

MasterTable2:

LOAD

LinkCommonDate, Cal_YearMonth as MonthYearQuarter

Resident Calendar_Year_2012;

Regards,

Renuka S