Discussion Board for collaboration on QlikView Layout & Visualizations.
Hi all ,
I created 'Volume; Buckets in a listbox using 'Class' function. It works fine .
The expression I used is : Replace(Class(VOLUME,10),'<= x <','to')
Here I got a problem at sorting . I was unable to sort it in Ascending order. Trust me I used all sorting options available in properties.
Any help would be appreciated.
Thanks in advance.
Go to Solution.
I suggest that you use this expression in your list:
=Dual(Replace(Class(VOLUME,10),'<= x <','to'), Num(Class(VOLUME,10)))
Now you should be able to sort the list box using a numeric sort.
Thanks so much . Its working.
You can probably skip the "Num" in the solution. The Class function returns a Dual value with an associated numeric value equal to the lower bound of each bucket.