Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to create max date in Filter

Hi All,

How to create max date in Filter(Qliksense)

Thanks,

Krishna

4 Replies
agigliotti
Partner - Champion
Partner - Champion

what do you mean with max date ?

what do you need to filter?

Anonymous
Not applicable
Author

Hi,

I need Max(Date), Max(Month). Max(Year) in Filter(Qliksense)

Regards,

Krishna

agigliotti
Partner - Champion
Partner - Champion

try below expression to have only max date in filter:

aggr( if( Date = firstsortedvalue( total Date, -Date), Date, null() ), Date)

kenphamvn
Creator III
Creator III

Try this

1-9-2018 4-36-12 PM.png

Regards

An Pham