How to create max date in Filter

[Anonymous]

Hi All,

How to create max date in Filter(Qliksense)

Thanks,

Krishna

[agigliotti]

what do you mean with max date ?

what do you need to filter?

[Anonymous]

Hi,

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

Regards,

Krishna

[agigliotti]

try below expression to have only max date in filter:

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

[kenphamvn]

Try this

Regards

An Pham