Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want Qliksense filter to display latest 3 year value. Please let me know how can i do that.
THanks,
Monu
=Aggr( If( Only(Year) >= Max(TOTAL Year,3) , Year) , Year)
May be
=IF(YourYearField >= Max({1}Total YourYearField )-2,YourYearField )
Could be this:
If (YearField>=Max(total YearField,3),YearField)