How to show only max two year in a multibox ?

[prahlad_infy]

Hello Sirs ,

How to show only max two year in a multibox , inspite loading all years ?

Thank You .

Test:

LOAD * INLINE [

    ID, Range, Year

    CH01, 0.502700197, 2001

    CH02, 0.38692753, 1999

    CH03, 0.912366489, 2002

    CH04, 0.055460904, 1995

    CH05, 0.628060836, 1998

    CH06, 0.074152319, 2003

    CH07, 0.64054428, 1996

    CH08, 0.994870245, 2004

    CH09, 0.102228268, 2001

    CH10, 0.258397399, 2002

    CH11, 0.505744914, 2004

    CH12, 0.092320997, 2002

    CH13, 0.007563945, 2002

    CH14, 0.322794789, 2001

    CH15, 0.419427596, 2001

    CH16, 0.713602826, 1998

    CH17, 0.059064041, 2001

    CH18, 0.006456316, 1995

    CH19, 0.588310561, 2003

    CH20, 0.150216099, 1998

    CH21, 0.306192771, 2004

    CH22, 0.211177971, 1996

    CH23, 0.113779187, 2001

    CH24, 0.221558725, 2001

    CH25, 0.788938283, 2003

    CH26, 0.643412974, 2000

    CH27, 0.24389364, 2000

    CH28, 0.590771294, 1998

    CH29, 0.153574557, 2004

    CH30, 0.637294808, 2001

    CH31, 0.474478611, 1999

    CH32, 0.777396374, 2002

    CH33, 0.790132291, 2004

    CH34, 0.116613634, 1998

    CH35, 0.024716965, 2002

    CH36, 0.278956744, 1997

    CH37, 0.444912219, 2004

    CH38, 0.652618788, 1999

    CH39, 0.098887196, 1998

    CH40, 0.317413343, 2000

    CH41, 0.885060694, 2000

    CH42, 0.765311297, 2002

    CH43, 0.398163524, 1996

    CH44, 0.483880004, 2004

    CH45, 0.315508414, 2004

    CH46, 0.593391377, 2004

    CH47, 0.567277848, 2004

    CH48, 0.190915147, 1997

    CH49, 0.328744997, 2004

    CH50, 0.119733427, 2000

    CH51, 0.445750652, 1997

    CH52, 0.043008271, 1998

    CH53, 0.920311628, 2000

    CH54, 0.372430054, 2001

    CH55, 0.7653644, 2002

    CH56, 0.886247501, 2002

    CH57, 0.520109055, 1999

    CH58, 0.452364852, 1998

    CH59, 0.271541908, 1998

    CH60, 0.58591263, 2004

    CH61, 0.138468943, 1995

    CH62, 0.770566722, 2003

    CH63, 0.188370088, 1997

    CH64, 0.25994357, 2000

    CH65, 0.519886602, 1998

    CH66, 0.999452993, 2003

    CH67, 0.823647457, 1997

    CH68, 0.425549167, 2002

    CH69, 0.219047684, 2001

];

[sunny_talwar · Accepted solution]

May be using an expression like this

=Aggr(Only({1<Year = {"$(=Max({1} Year))", "$(=Max({1} Year, 2))"}>} Year), Year)

[simospa]

Hi,

you could manage it by load script:

1. add to edit script something like

Years:

FIRST 2 LOAD distinct Max(Year) as Year,

'y' as isMax

Resident Test

group by Year

Order by Year desc;

and then in the listbox expression:

=if(isMax='y', Year)

Simone

[rajivmeher]

Hi prahlad.infy‌

Have you tried the following?

On Multibox properties:

- On sort Tab - Change the sort order to number descending.

- On Presentation Tab - Limit Drop-down to 2.

Regards

Rajiv.

[prahlad_infy]

Sir , i knew this .. but it shows other years as well on scroll , which was not the requirement .

Thank You .

[rajivmeher]

Hi prahlad.infy‌

Thanks for your feedback.

Regards

Rajiv.