topic Re: cusom sort in qlikview in QlikView

cusom sort in qlikview

Fri, 28 Feb 2014 06:11:45 GMT

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??

tresB — Fri, 28 Feb 2014 06:17:28 GMT

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 — Fri, 28 Feb 2014 06:34:14 GMT

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

Fri, 28 Feb 2014 06:55:02 GMT

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