cusom sort in qlikview

[#1]

Hi,

Is anyone have idea how to sort customly.Like I have month names and I want to sort like January,February etc.

How to sort like this??

[tresesco · Accepted solution]

You can create an inline table in the script like:

Load * Inline [

Month, Num

Jan, 1

Feb, 2

.....

];

and then use Num field in the front end for sorting expression.

Or, in the front end can use sort expression like:

=Match( MonthField, 'Jan', 'Feb', .....)

[er_mohit]

in sort tab of any object for expression side write

dual(if(match(Monthname,'January',1,if(match(Monthname,'February',2)) like this way

and if you want to do it on script side then load from inline and make it value like

Monthname,Value

January,1

February,2

etc

[#4]

Thanks....its working...!!!