topic Re: Listbox years issue in App Development

Listbox years issue

Martin098 — Tue, 26 Jul 2022 15:01:56 GMT

Hi all,

I'm new to qlikview, I'm facing a issue. Here I have a horizontal listbox for years from 2022 to 1970. But I want display only from 2022 to 2015. I want to do this changes using UI not in script. How to solve this issue with expression or how?

Thanks in advance

Re: Listbox years issue

hic — Tue, 26 Jul 2022 15:53:56 GMT

=Aggr(Only({1<Year={">=2015<=2022"}>} Year),Year)

Re: Listbox years issue

Martin098 — Wed, 27 Jul 2022 05:54:36 GMT

Hi Henric_Cronström

Thanks for your reply and time . It not working for me.

Here I have a list box like this type of example

Year 2022 2021 2020 2019 ..........1990

But I want to show like this way

Year 2022 2021 2020 2019..........2015.

Thanks in advance

Re: Listbox years issue

fallenangel6 — Wed, 27 Jul 2022 06:23:27 GMT

Hernic's formula is working for me. it has already put set expression to restrict values upto 2015. could you share what is coming as the output when you apply that formula?

Re: Listbox years issue

Martin098 — Wed, 27 Jul 2022 15:41:50 GMT

I have attached a document about my issue please have look.

Thank you

Re: Listbox years issue

MarcoWedel — Wed, 27 Jul 2022 17:26:33 GMT

You have to apply this expression here:

NOT here: