Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
In the sort tab u can check the box for Sort as Ascending and Load Order as Original.....Hope this is what u wanted!!!
I understand your ask now, sorry for the misunderstanding. Unfortunately, I'm not really sure how you could accomplish this.