Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Display last 24 months based on a selection

Hello All!

  I am new to QlikView and I am trying to create a chart displaying the Current Quarter and the last 2 years (last 24 months) based on a selection. For example, if the User selected 2017 and 1st Quarter, it will display the current Quarter data and the last 24 months (or 8 quarters).  Below is a mock screen of what I am trying to accomplish. Any help will be greatly appreciated.

Below is what I have so far -- but having problem on displaying the last 24 months.

Thank you so much!!!!

2 Replies
jcs_2015
New Contributor III

Re: Display last 24 months based on a selection

Ray,

Take a look at the attached.  I've used variables to set your backwards looking rolling 24 month range based on the section of MonthYear.  Hopefully you can use this as a guide and modify it to Quarter.

I do see a potential data table issue though.  You have Year and Quarter, but not Quarter-Year as a singular dimension.  Not sure what your use case is re selections, but it might make more sense to create the extra field and only present that dimension for sections.

Jim

vishsaggi
Esteemed Contributor III

Re: Display last 24 months based on a selection

What is the expression you are trying for Previous Years. May be try this?

= Sum({$< Year = {$(= Max(Year)-2) }  >}Value)

Community Browser