Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
krishna4bo
Creator
Creator

How to create max date in Filter

Hi All,

How to create max date in Filter(Qliksense)

Thanks,

Krishna

4 Replies
agigliotti
Partner - Master III
Partner - Master III

what do you mean with max date ?

what do you need to filter?

krishna4bo
Creator
Creator
Author

Hi,

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

Regards,

Krishna

agigliotti
Partner - Master III
Partner - Master III

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