topic Show only specific years in listbox in QlikView

Show only specific years in listbox

t_hylander — Thu, 09 Feb 2023 16:10:41 GMT

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... 🙂

Re: Show only specific years in listbox

hic — Thu, 09 Feb 2023 16:25:44 GMT

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)

Re: Show only specific years in listbox

t_hylander — Tue, 14 Feb 2023 09:02:17 GMT

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

Thanks, it works like a charm!