Two years Date range

[#1]

Hi All,

I have a doubt, can any one help me out.

I have a columns like

1. Quarter_year

2. Year

3. Date

Data:

We have 2014 January to till date.

I want show expression output like : January 2014 to December 2016

Can any one help me with expression.

Note:

1.Metric has to be set for 2 years .

2 date as date range as to be 2 years

Thanks.

[Gysbert_Wassenaar]

This expression returns the result you want ='January 2014 to December 2016'

Now please explain what you're really trying to do. An example with some data would be useful.

[Anonymous]

Hi Nanda,

You can do it with year field: Max(Year)-2

Regards!!

[#4]

Hi Gys,

I have been attached QVW Can you please check once.

Edit Script  have inline Data.

Thanks