Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Martin098
Contributor II
Contributor II

Listbox years issue

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 

Labels (1)
2 Solutions

Accepted Solutions
hic
Employee
Employee

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

View solution in original post

MarcoWedel

You have to apply this expression here:

 

MarcoWedel_0-1658942610387.png

 

MarcoWedel_4-1658942755545.png

 

MarcoWedel_3-1658942719214.png

 

 

 

 

 

NOT here:

MarcoWedel_2-1658942671570.png

 

 

 

 

 

 

View solution in original post

5 Replies
hic
Employee
Employee

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

Martin098
Contributor II
Contributor II
Author

Hi Henric_Cronströ

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 

 

fallenangel6
Creator
Creator

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?

Martin098
Contributor II
Contributor II
Author

Hi 

 

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

Thank you 

MarcoWedel

You have to apply this expression here:

 

MarcoWedel_0-1658942610387.png

 

MarcoWedel_4-1658942755545.png

 

MarcoWedel_3-1658942719214.png

 

 

 

 

 

NOT here:

MarcoWedel_2-1658942671570.png