Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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
Champion

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