Filter

[sarasmonu]

Hi All,

I want Qliksense filter to display latest 3 year value. Please let me know how can i do that.

THanks,

Monu

[petter]

=Aggr( If( Only(Year) >= Max(TOTAL Year,3) , Year) , Year)

[MK_QSL]

May be

=IF(YourYearField >= Max({1}Total YourYearField )-2,YourYearField )

[Thiago_Justen_]

Could be this:

If (YearField>=Max(total YearField,3),YearField)