topic Re: Issue in list box for years in QlikView

Issue in list box for years

Tue, 14 Jul 2015 15:58:33 GMT

Can someone please tell me the expression for excluding past three years from the list box dynamically.

sunny_talwar — Tue, 14 Jul 2015 15:59:52 GMT

Exclude past three years or include them?

sunny_talwar — Tue, 14 Jul 2015 16:01:09 GMT

Exclude may be this:

If(not Match(Year, Max({1}Year), Max({1}Year, 2), Max({1}Year, 3)), Year)

Include:

If(Match(Year, Max({1}Year), Max({1}Year, 2), Max({1}Year, 3)), Year)

ramoncova06 — Tue, 14 Jul 2015 16:02:27 GMT

this is to only show the last three years

aggr(only({<Year = {">=$(max(Year,3))"}>}Year),Year)

this is to exclude the last three year

aggr(only({<Year = {"<=$(max(Year,3))"}>}Year),Year)

antoniotiman — Tue, 14 Jul 2015 16:20:01 GMT

Hi,

Try

=Aggr(DISTINCT If(Rank(TOTAL -YEAR) > 3,YEAR),YEAR)

Regards