topic Re: Pick top 2 values in list box? in QlikView

Pick top 2 values in list box?

swarup_malli — Wed, 20 Mar 2013 12:53:07 GMT

Hi ,

I have a list box which has values from 2008 to 2013.

I want the listbox to display current year and previous year ( ie 2012 and 2013)

I know this can be achieved using the expression inside the list box.

My requirement is I don't want to hardcode year in order to pick top 2 values.

I tried using the following expression inside the listbox

if (year=max(year) or year=max(year-1))

But the thing is when I click on 2012 in the list box ,it show 2011.

Is there a way this can be achieved without hardcoding year values ?

Thanks

Gysbert_Wassenaar — Wed, 20 Mar 2013 13:13:22 GMT

Something like this: =aggr(if(rank(Year)<=2,Year),Year)

If you want you could also replace the 2 with a variable so you can change the top x by changing the value of the variable.

swarup_malli — Wed, 20 Mar 2013 13:15:25 GMT

Thank you !!! Gysbert

swarup_malli — Thu, 21 Mar 2013 18:23:22 GMT

Hey Gysbert,

When i make a selection in list box, say I choose 2013, then all other values disappear, how can I not make them disappear ?

I don't want to hard code any year

CELAMBARASAN — Thu, 21 Mar 2013 19:54:03 GMT

Try with this

=If(Match(Year, Max({1} Year), Max({1}Year)-1)), Year)

Edit:

=If(Match(Year, $(=Max({1} Year)), $(=Max({1} Year)-1)), Year)

Hope it helps

Celambarasan

Anonymous — Fri, 12 Apr 2013 20:01:37 GMT

In the expresssion

=If(Match(Year, $(=Max({1} Year)), $(=Max({1} Year)-1)), Year)

wt does {1} stand for ?

Balraj

swarup_malli — Fri, 12 Apr 2013 20:55:44 GMT

I guess {1} represents the full set of all the records in the application

Fri, 14 Feb 2014 18:43:55 GMT

Excellentooo..!! it solved dropdown filter issue. Thanks boss.