Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In a chart i have a dimension that displays the year and month for the current month all the way back to March 2014. In the chart itself I want to limit the display of this dimension to just the past three months. Not sure how to proceed on how to do this.
You can limit by using set analysis in expression or by using calculated dimension in dimension tab
Limit it with your variable which you can dynamically change.
Check my attached file
There are a number of ways to do this. Can you post a qlikview document with sample data? See this document: Preparing examples for Upload - Reduction and Data Scrambling
it is a pivot table so there is no 'dimension limits' tab
See an example based on the "demo script" (CTRL+Q+Q)