Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Sorting of Buckets in a Listbox


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.

Best Regards,

Susvith

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Sorting of Buckets in a Listbox

Hi

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.

HTH

Jonathan

3 Replies
MVP
MVP

Re: Sorting of Buckets in a Listbox

Hi

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.

HTH

Jonathan

Not applicable

Re: Sorting of Buckets in a Listbox

Thanks so much . Its working.


Highlighted
msteedle
Contributor

Re: Sorting of Buckets in a Listbox

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.

Community Browser