Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Bar chart piled based in date range filter and previous years

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

range_date_dimension.png

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

0 Replies