Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

List Box Expression

Hello All,

I have a list box properties which is looking for a dimension calendar year, from 2011 to 2020

I want to use field as a expression and use a formula that only shows 3 years prior the current. Does anyone knows which formula can I use?

Thanks

Joanna

1 Solution

Accepted Solutions

Re: List Box Expression

Hi Joanna,

=If(Year <= Year(Today()) and Year >= Year(Today())-3, Year)

Or

=Aggr(Only({<Year={">=$(=Year(Today())-3)<=$(=Year(Today()))"} >}Year),Year)

3 Replies

Re: List Box Expression

Hi Joanna,

=If(Year <= Year(Today()) and Year >= Year(Today())-3, Year)

Or

=Aggr(Only({<Year={">=$(=Year(Today())-3)<=$(=Year(Today()))"} >}Year),Year)

Not applicable

Re: List Box Expression

Thanks so much Tamil appreciate your help =)

Re: List Box Expression

Anytime. Kindly close the thread, if your query was answered. Thank you and have a nice day.

Qlik Community Tip: Marking Replies as Correct or Helpful

Community Browser