Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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.

anavin33
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
Not applicable

Re: Limiting a dimension

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

thomas_kuler
Not applicable

Re: Limiting a dimension

Limit it with your variable which you can dynamically change.

Check my attached file

Gysbert_Wassenaar
Not applicable

Re: Limiting a dimension

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
anavin33
Not applicable

Re: Limiting a dimension

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

mov
Not applicable

Re: Limiting a dimension

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