Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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
Partner

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
Partner

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