topic Re: How to show only max two year in a multibox ? in QlikView

How to show only max two year in a multibox ?

prahlad_infy — Wed, 25 Nov 2020 16:16:04 GMT

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

];

Re: How to show only max two year in a multibox ?

sunny_talwar — Fri, 31 Aug 2018 13:05:53 GMT

May be using an expression like this

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

Re: How to show only max two year in a multibox ?

simospa — Fri, 31 Aug 2018 13:11:51 GMT

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

Re: How to show only max two year in a multibox ?

rajivmeher — Fri, 31 Aug 2018 21:39:11 GMT

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.

Re: How to show only max two year in a multibox ?

prahlad_infy — Mon, 03 Sep 2018 12:13:48 GMT

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

Thank You .

Re: How to show only max two year in a multibox ?

rajivmeher — Tue, 04 Sep 2018 07:47:58 GMT

Hi prahlad.infy‌

Thanks for your feedback.

Regards

Rajiv.