topic Re: Customized List Box in QlikView

Customized List Box

azmeerrehan — Wed, 19 Jul 2017 13:52:20 GMT

In my data set I have Years like 2018,2017,2016, etc. I dont want to limit the script for 2018, but on the list box I would like to see only Current and 3 Prev years, how can I do that ?

Re: Customized List Box

Anil_Babu_Samineni — Wed, 19 Jul 2017 13:57:18 GMT

One best solution this for expression in list box rather direct field

If(Year <> 2018, Year)

Re: Customized List Box

Kushal_Chawda — Wed, 19 Jul 2017 14:04:29 GMT

=aggr(if(YearField>= year(addyears(today().-3)) and YearField<= year(today()), YearField),YearField)

Re: Customized List Box

suryaa30 — Wed, 19 Jul 2017 14:15:39 GMT

Create below variables:

vNow: Date(max(TOTAL DateYearField))

vPrev3: $(vNow)-AddYears($(vNow),-3)

Then in list box use below condition. in drop down select expression at the bottom most.

=if(($(vNow) - DateYearField))>0) and ($(vNow) - DateYearField))<= $(vPrev3)),DateYearField)

Re: Customized List Box

antoniotiman — Wed, 19 Jul 2017 14:47:46 GMT

Maybe

=IF(Year >= Year(Now())-3 and Year <= Year(Now()),Year)

Re: Customized List Box

azmeerrehan — Wed, 19 Jul 2017 15:19:53 GMT

Syntax does not look right

Re: Customized List Box

Kushal_Chawda — Wed, 19 Jul 2017 15:32:12 GMT

Or try this

AGGR(If(YEAR>= year(today()) - 3 and YEAR <=year( today()), YEAR), YEAR)

Re: Customized List Box

passionate — Wed, 19 Jul 2017 15:42:57 GMT

Simple way to do this is using calculated expression in listbox:

=Valuelist(Year(Today()),Year(Today())-1,Year(Today())-2,Year(Today())-3)