Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Trending Analysis in QV

Hi All,

I'm pretty new to Qlikview and have been playing around with set analysis but cannot seem to get the logic on how to implement trending. Here's what I'm trying to achieve:

I have the following fields 

  1. Reporting Period - Displays all months ex. Jan-2011, Feb-2011.....Dec-2011. This is a calculated field from a time dimension table by concatenating the Month and Year fields.
  2. Month_Num - Numeric field that gives number of current month. Ex Jan-2011 is '1' , Feb-2011 is '2' , etc.
  3. Field X - The field on the Y-axis that could be a cost or something like that.

1.jpg2.jpg

As you can see these are the two sheet objects I have. Now what I want is if I select a particular month, based on my current selection the logic should look back six months and display all the corresponding data.

For example:

If I select Jan-2011, I should get data only for Jan-2011, if I select Mar-2011 I should get data for Jan, Feb and March-2011. Similarly if I select Oct-2011, I should get data from May-2011-Oct-2011 i.e. data for the last six months including current selected month.