# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Contributor II

## How to limit the years in hierarchy calendar list box

Hi Experts,

I have Hierarchy calendar list box. In the list box i have the years from 1900 but i want to limit the years in my list box.

I want to show the hierarchy years from 2005 only

Can you guys please suggest how to do that

1 Solution

Accepted Solutions
Highlighted
Honored Contributor II

## Re: How to limit the years in hierarchy calendar list box

In script in Main3 Tab change this:

let vMinDate = Floor(YearStart(Peek('MinDate',-1,'Temp')));

to:

let vMinDate = Num(MakeDate(2005,1,1));

5 Replies
Highlighted
Contributor II

## Re: How to limit the years in hierarchy calendar list box

Can you please look for this

Highlighted
Honored Contributor II

Highlighted
Contributor II

## Re: How to limit the years in hierarchy calendar list box

Hi Frank,

Here i am attaching my qvw. Please find it give the possible solution

Highlighted
Honored Contributor II

## Re: How to limit the years in hierarchy calendar list box

In script in Main3 Tab change this:

let vMinDate = Floor(YearStart(Peek('MinDate',-1,'Temp')));

to:

let vMinDate = Num(MakeDate(2005,1,1));

Highlighted
Contributor II

## Re: How to limit the years in hierarchy calendar list box

Hi Frank,

Thank you very much for the solution. It's working.

If you have time please check whole script and expressions. and please give your inputs and suggestions

Thank you