topic Re: Rank function for non-numeric values in QlikView

Rank function for non-numeric values

Wed, 11 Mar 2015 10:17:58 GMT

Hello,

I have a Segment field with values 'H', 'M', 'L'

To sort these, I am not able to use load order, alphabetical, etc. Without adding an INLINE table to the script, is it possible to use tha Rank function to order my segments like H, M, L in my table?

Many thanks

Mel

Re: Rank function for non-numeric values

MK_QSL — Wed, 11 Mar 2015 10:22:04 GMT

Use as below..

Load

Dual(Field,Ord(Field)) as Field

Inline

[

Field

];

Now you can sort by ascending or descending order.

Re: Rank function for non-numeric values

Wed, 11 Mar 2015 10:23:47 GMT

Hi Manish,

Thank you very much for this. I'm not able to touch the load script, however. Is it possible to accomplish similar from a calculated dimension or from Sort at a chart level?

Thanks

Mel

Re: Rank function for non-numeric values

Wed, 11 Mar 2015 10:23:47 GMT

Hi mvankluyve,

you won't be able to use rank like this, you could potentially load your field as a dual() so that each value does have an underlying numerical value for you to sort using.

The other option you have is to sort via an expression and define the order within this.

Hope that helps

Joe

Re: Rank function for non-numeric values

Gysbert_Wassenaar — Wed, 11 Mar 2015 10:25:40 GMT

You can use an expression to sort the chart. On the Sort tab choose the option Sort By Expression and use this expression: =match(only({1}Segment), 'H','M','L')

Re: Rank function for non-numeric values

Wed, 11 Mar 2015 10:28:34 GMT

Brilliant - thanks so much, Gysbert!