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