Discussion Board for collaboration on QlikView Layout & Visualizations.
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??
You can create an inline table in the script like:
Load * Inline [
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
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