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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
durgabhavani
Creator III
Creator III

How to restrict values in list box?

Hi All,

I have dates for ten years in my calender object. (I am using date field from database in calender object)

But i don't want to display all 10 years values in calender. I need to display just latest year (2015) values in my calender.

(date format in my calender: mm/dd/yyyy.)

Please advice!

Thanks,

Durga

10 Replies
petter
Partner - Champion III
Partner - Champion III

In this expression:   

      Only({<Date = {"=Year(Date) = 2015"}>} Date)

the set expression will return multiple dates if there are more than one row returned for any given date - and then Only() will not accept this but return NULL.