Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Calendars

Within a calendar, can you limit the years to be displayed in your application.  Lets say you have data covering the following years:

2009

2010

2011

2012

2013

2014

Can i restrict my calendar to say the last three years or something like that?  Thank you in advance.

13 Replies
SunilChauhan
Champion II
Champion II

thanks anand .

we could also use conditions without if as they are consuming memory

Load

*

where Year >= Year( Today() ) - 2;

LOAD * Inline

[

Year

2009

2010

2011

2012

2013

2014

]

;

Sunil Chauhan
Anonymous
Not applicable
Author

Thank you all for your valuable inputs, most appreciated.

Not applicable
Author

Hi,

In the load script you can achieve this by

Data:

LOAD * Inline

[

Year

2009

2010

2011

2012

2013

2014

]

Where Year >= Year( Today() ) - 2 AND Year <= Year( Today() );

Anonymous
Not applicable
Author

Hi Many thanks