Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
bvssudhakar
Creator III
Creator III

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

Thank you in advance

1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

In script in Main3 Tab change this:

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

to:

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

View solution in original post

5 Replies
bvssudhakar
Creator III
Creator III
Author

franky_h79

Can you please look for this

Frank_Hartmann
Master II
Master II

can you attach your qvw?

bvssudhakar
Creator III
Creator III
Author

Hi Frank,

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

Thank you in advance

Frank_Hartmann
Master II
Master II

In script in Main3 Tab change this:

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

to:

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

bvssudhakar
Creator III
Creator III
Author

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