topic Re: Display last 24 months based on a selection in QlikView

Display last 24 months based on a selection

Mon, 27 Feb 2017 20:07:59 GMT

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!!!!

Re: Display last 24 months based on a selection

jcs_2015 — Thu, 02 Mar 2017 22:03:49 GMT

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

Re: Display last 24 months based on a selection

vishsaggi — Thu, 02 Mar 2017 22:17:11 GMT

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

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