Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

NoteSmiley Very Happyon't concentrate on those which are not selected.

Thanks in Advance!!

Have a great Day!!

Santosh

Tags (1)
4 Replies
kmcgovern1
Contributor

Re: Sorting as per selection in a list box

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

Re: Sorting as per selection in a list box

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

Re: Sorting as per selection in a list box

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

kmcgovern1
Contributor

Re: Sorting as per selection in a list box

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

Community Browser