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: 
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.