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: 
enricocamerin
Creator
Creator

show a default value in a filter

Hello I have a date filter and and I need to show a fix value so the user doesn't has to pick up the date.

the default value is the last database loading. I have this date but I can't set it as default value in the filter

thanks

Enrico

enricocamerin_0-1681808659675.png

 

Labels (1)
3 Replies
Velvet_Crowe
Contributor III
Contributor III

Hello,
I think this could be done only by a bookmark as explained here Always one selected value - Max Date 

enricocamerin
Creator
Creator
Author

thanks but I can't get it working. If I type =max (date) in the search filter  it will show all the possible date 

Velvet_Crowe
Contributor III
Contributor III

Hi,

if [Event Date] is your date field this should work:

=[Event Date]=Max(total [Event Date])