Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Restricting date field for 1 month.

Hi I have a field called TIME_ID which has value of dates for 2 years.I want to display only dates for the month of june(20130601 to 20130630) in TIME_ID filed.

How can I do this?Please help me.

Thanks in advance for your help.

1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

Have a list box with expression

if(TIME_ID>=20130601 and TIME_ID <= 20130630, TIME_ID)

View solution in original post

2 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Have a list box with expression

if(TIME_ID>=20130601 and TIME_ID <= 20130630, TIME_ID)

Not applicable
Author

I would add a Slider/Calendar Object and point it to your TIME_ID field.  This would allow you to make a selection of any date range you would like and would not require you to hard-code any date range.