topic Re: List Box Object Issue in QlikView

List Box Object Issue

Tue, 19 Jan 2016 19:37:06 GMT

I have a list box for Year and I have 10 Years in the list box like 2015,2014,2013,2012,...............etc.

I would like to display only 3 years (2015,2014,2013). I still want the data for all the years but just for list box I need only 3 years. So the end user will not be able to select anything beyond 3 Years.

Is that doable and how can we do that

Re: List Box Object Issue

sunny_talwar — Tue, 19 Jan 2016 19:38:14 GMT

Try this:

If(Match(Year, 2013, 2014, 2015), Year)

Alternatively this should also work:

=Aggr(Only({<Year = {'2013', '2014', '2015'}>} Year), Year)

Re: List Box Object Issue

Tue, 19 Jan 2016 19:46:30 GMT

I wanna use dynamic year, like MAx Year, MAx(Year)-1 etc

Re: List Box Object Issue

sunny_talwar — Tue, 19 Jan 2016 19:51:37 GMT

May be this:

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

Re: List Box Object Issue

Tue, 19 Jan 2016 19:53:15 GMT

Sorry I meant Year(Today()), Year(Today()-1 etc

Re: List Box Object Issue

sunny_talwar — Tue, 19 Jan 2016 19:56:12 GMT

Try this:

=Aggr(Only({<Year = {$(=Year(Today())), $(=Year(Today())-1), $(=Year(Today())-2)}>} Year), Year)