topic Re: Sorting as per selection in a list box in QlikView

Sorting as per selection in a list box

Tue, 08 Jan 2013 19:25:01 GMT

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

Re: Sorting as per selection in a list box

Anonymous — Tue, 08 Jan 2013 21:19:07 GMT

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

Re: Sorting as per selection in a list box

Wed, 09 Jan 2013 09:40:39 GMT

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

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

The answer that you gave will give me always

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

thx

Re: Sorting as per selection in a list box

Wed, 09 Jan 2013 14:57:48 GMT

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

Re: Sorting as per selection in a list box

Anonymous — Wed, 09 Jan 2013 15:21:14 GMT

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