topic Re: How to restrict fields in a list box in QlikView

How to restrict fields in a list box

paul_ripley — Tue, 17 Apr 2018 11:56:17 GMT

Hello

My data has 2017 and 2016 years in it

I only want to show 2017 year in the selections.

How could I restrict this?

any thanks

Paul

Re: How to restrict fields in a list box

sunny_talwar — Tue, 17 Apr 2018 12:03:05 GMT

May be like this

Aggr(Only({1<Year = {'2017'}>} period), period)

Re: How to restrict fields in a list box

sergio0592 — Tue, 17 Apr 2018 12:04:11 GMT

Hi, try with : =if(match(mid(Period,1,4),'2017')>0,Period)

Re: How to restrict fields in a list box

sunny_talwar — Tue, 17 Apr 2018 12:05:30 GMT

or this

Aggr(Only({1<period = {"2017*"}>} period), period)

Re: How to restrict fields in a list box

stigchel — Tue, 17 Apr 2018 12:06:28 GMT

In the listbox properties field selection scroll down to the bottom of the list with fields and choose expression. For the expression use somthing like this:

=Aggr(Only({<period={'*'}-{"2016*"}>} period),period)

Re: How to restrict fields in a list box

paul_ripley — Tue, 17 Apr 2018 15:41:09 GMT

Thanks all for trying but they still show in the screen, usually looking something like below

Re: How to restrict fields in a list box

sunny_talwar — Tue, 17 Apr 2018 15:42:21 GMT

On the general tab and not on the expressions tab

Re: How to restrict fields in a list box

paul_ripley — Tue, 17 Apr 2018 15:52:43 GMT

Thank you. I'm a bit of a novice at QV!