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

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
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.

Labels (1)
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.