Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sorting as per selection in a list box

Hi everyone,

Can anybody help me achieve list box sorting dynamically as per our selection(for those items which are not selected that we can avoid, I mean I am not concerned for those)

I have six items in my list box,they are listed below

Product Volume       

Product Volume Change

Market Share Volume  

Market Share Change  

Net to Market        

National Net to Market

I want my list box to sort these values at the front end in the way they are selected.

e.g when I select National Net to Market, Product Volume & Net to Market    then my list box item should be like

National Net to Market

Product Volume       

Net to Market      

Product Volume Change

Market Share Volume  

Market Share Change  

 

when I select Product Volume Change,  Market Share Volume  & Market Share Change       then my list box item should be like

   

Product Volume Change

Market Share Volume  

Market Share Change  

Product Volume   

Net to Market        

National Net to Market

Note:Don't concentrate on those which are not selected.

Thanks in Advance!!

Have a great Day!!

Santosh

4 Replies
Anonymous
Not applicable
Author

In the list box properties, under the sort tab, if you select State=Ascending, your selected values will always come to the top of the list box.

Added sample file with change

Not applicable
Author

Thanks Kenvin,

I think I could not convey my question clearly, the sorting order should be synchronised with your current selection.

Let's say we have a list box with value 1, 2 & 3.

If we select first 2 then 3 then 1 then the order in the list box should be

2

3

1

If we select first 3 then 2 then 1 then the order in the list box should be

3

2

1

The answer that you gave will give me always

1

2

3

But I need Qlikview to remember my current selection order & then do the adjustment accordingly.

thx

Not applicable
Author

In the sort tab u can check the box for Sort as Ascending and Load Order as Original.....Hope this is what u wanted!!!

Anonymous
Not applicable
Author

I understand your ask now, sorry for the misunderstanding.  Unfortunately, I'm not really sure how you could accomplish this.