Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

cusom sort in qlikview

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

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: cusom sort in qlikview

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', .....)

View solution in original post

3 Replies
Highlighted
MVP
MVP

Re: cusom sort in qlikview

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', .....)

View solution in original post

Highlighted
Honored Contributor II

Re: cusom sort in qlikview

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

Highlighted
Not applicable

Re: cusom sort in qlikview

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