Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

sarasmonu
New Contributor III

Filter

Hi All,

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

THanks,

Monu

3 Replies
MVP
MVP

Re: Filter

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

Re: Filter

May be

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

thiago_justen
Valued Contributor III

Re: Filter

Could be this:

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

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
Community Browser