Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
];
May be using an expression like this
=Aggr(Only({1<Year = {"$(=Max({1} Year))", "$(=Max({1} Year, 2))"}>} Year), Year)
May be using an expression like this
=Aggr(Only({1<Year = {"$(=Max({1} Year))", "$(=Max({1} Year, 2))"}>} Year), Year)
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
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.
Sir , i knew this .. but it shows other years as well on scroll , which was not the requirement .
Thank You .