topic Re: Two years Date range in QlikView

Two years Date range

Wed, 25 Nov 2020 16:16:04 GMT

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 — Wed, 10 Aug 2016 07:20:16 GMT

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 — Wed, 10 Aug 2016 08:26:03 GMT

Hi Nanda,

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

Regards!!

Wed, 10 Aug 2016 15:40:28 GMT

Hi Gys,

I have been attached QVW Can you please check once.

Edit Script have inline Data.

Thanks