Show only specific years in listbox

[t_hylander]

Hi,

I've got a simple listbox with all availble years, what I want is that if a specific cirteria is met only some of the years should show.

Tried using IF-statement in expression under Field, but I cant get it to work.
ex. =if(State='1',Year='2023',Year)

Did som other versions aswell...

Should be fairly simple I think but until you know... 🙂

[hic · Accepted solution]

The best way is to use an Aggr() with set analysis. For example

=Aggr(Only({1<State={1}>}Year), Year)

will show the years where State='1'.

Note: This expression should NOT be entered on the expressions tab in the list box properties. It should be entered on the General tab:
General --> Field --> <Expression> (bottom of the list)

[t_hylander]

Ah, ofcourse...makes sense now when I see it 🙂

Thanks, it works like a charm!