Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Limiting a dimension

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.

5 Replies
MK_QSL
MVP
MVP

You can limit by using set analysis in expression or by using calculated dimension in dimension tab

Anonymous
Not applicable
Author

Limit it with your variable which you can dynamically change.

Check my attached file

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

it is a pivot table so there is no 'dimension limits' tab

Anonymous
Not applicable
Author

See an example based on the "demo script" (CTRL+Q+Q)