Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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
Former Employee
Former 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
Former Employee
Former 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