Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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