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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
venkat1
Creator II
Creator II

How to remove specific years from the calendar

Hi ,

how to not to show specific years in calendar?

2 Replies
shiveshsingh
Master
Master

What about not loading or creating the calendar for those years in script itself?

JordyWegman
Partner - Master
Partner - Master

Hi,

Try this:

Calendar:
Load 
  *
From [YourSource] (qvd)
Where Year <> 2012
;

You can do this hard coded.

Jordy

Climber

Work smarter, not harder