Discussion Board for collaboration on QlikView Layout & Visualizations.
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 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
Net to Market
when I select Product Volume Change, Market Share Volume & Market Share Change then my list box item should be like
Noteon't concentrate on those which are not selected.
Thanks in Advance!!
Have a great Day!!
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
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.
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.