topic Re: Class Sorting Order in QlikView

Class Sorting Order

Anonymous — Sun, 19 Jan 2014 16:29:32 GMT

Hi Genuises,

I got stuck in class sorting order

I have made a class like this below:

=SubField(Class(Due,$(vWidth)),'<=',1) & 'to' & SubField(Class(Due,$(vWidth)),'x <',2)

vWidth is the dynamic variable which I am taking from input box

and I am using the above class function as dimension and my expression is Sum(AmCurrLocal)

The dimension is come like 0 to 30, 60 to 90 , 30 to 60 and so on

But its not in a sorted order

Please help me to get it sorted

I have to submit this in 4 hours

Pls pls help me

Thanks in advance

Shashank

Re: Class Sorting Order

MK_QSL — Sun, 19 Jan 2014 17:19:39 GMT

Go to SORT tab

Sort Your Aggregated Dimension by Numeric Value - Ascending Order

Rest all should be UNTICK

Re: Class Sorting Order

Anonymous — Sun, 19 Jan 2014 17:24:40 GMT

It's not working

Re: Class Sorting Order

Anonymous — Sun, 19 Jan 2014 17:31:48 GMT

I have a similar problem that I haven't figured out myself. If anyone can figure this out it would be much appreciated.

BUMP

Re: Class Sorting Order

Gysbert_Wassenaar — Sun, 19 Jan 2014 17:36:26 GMT

The class function returns values with both a text format and a numeric value. So the results of the class function can be sorted by Numeric Value - Ascending. What you folks are doing is creating a pure text value by using the subfield or replace functions on the result of the class function. The resulting text values cannot be sorted numerically. What you could do is create a dual value again using the dual function: dual( subfield_expression_here , class_expression_here )

Re: Class Sorting Order

MK_QSL — Sun, 19 Jan 2014 17:44:36 GMT

Try Text - Sort A-Z

Re: Class Sorting Order

Anonymous — Sun, 19 Jan 2014 18:11:02 GMT

It worked! Thanks!

Re: Class Sorting Order

Anonymous — Sun, 19 Jan 2014 18:15:38 GMT

Try:

=dual(replace(Class(Due,$(vWidth)),'<= x <','to'),Class(Due,$(vWidth)))

Then sort by Numerical Value

Re: Class Sorting Order

PaulVanSiclen — Thu, 30 Apr 2015 17:20:05 GMT

Thanks Michael, this worked perfectly in my Qlik Sense app!