Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

How to show only max two year in a multibox ?

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

];

1 Solution

Accepted Solutions
Highlighted

May be using an expression like this

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

View solution in original post

5 Replies
Highlighted

May be using an expression like this

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

View solution in original post

Highlighted
Partner
Partner

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

Highlighted
Creator
Creator

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.

Highlighted
Creator
Creator

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

Thank You .

Highlighted
Creator
Creator

Hi prahlad.infy

Thanks for your feedback.

Regards

Rajiv.