Bar chart piled based in date range filter and previous years

Anonymous — Wed, 25 Oct 2017 07:21:58 GMT

Hi everyone,

I'm trying to get this one and can't think of a way. After several days trying I'm finally asking for advise here.

What I'm trying to acomplish is as followed:

Once user Filters a date range (i.e: 01/04/2013 - 01/04/2014)

Getting values for the filtered dates: date={">=$(=DATE(Min(fec)))<=$(=DATE(Max(fec)))"}

Same period for the previous year: date={">=$(=DATE(AddYears(Min(fec),-1)))<=$(=DATE(AddYears(Max(fec),-1)))"}

As well as for same period two years prior: date={">=$(=DATE(AddYears(Min(fec),-2)))<=$(=DATE(AddYears(Max(fec),-2)))"}

Using as dimension: year(date)

I get as followed, what I would like to achieve is piled for each of 3 ranges

Thanks in advance to anyone that can shed some light here!!!

topic Bar chart piled based in date range filter and previous years in QlikView