Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Custom sorting of a dimension in a bar graph

Got a graph that looks like this: http://i48.tinypic.com/2crk6j9.png

I want to sort the dimensions in the following order:

Offered/Hired

Hiring Team Interview

HR/Tech Screening

New Applicant

1 Solution

Accepted Solutions
Highlighted
Luminary
Luminary

It would be excellent if you could assign a number value to these concepts from the data modelo so that you can just sort on that value, but if not in the sort tab, select the dimension and enable the option to sort by expression.  The expression is going to be:

=match(DimensionField,'Offered/Hired','Hiring Team Interview','HR/Tech Screening','New Applicant')

The match function returns the number in the list where the dimension value is found.  For example Offered/Hired will return a 1 and HR/Tech Screening will return a 3.  This should allow you to sort the graph in the way you order your match list.

Karl

View solution in original post

2 Replies
Highlighted
Luminary
Luminary

It would be excellent if you could assign a number value to these concepts from the data modelo so that you can just sort on that value, but if not in the sort tab, select the dimension and enable the option to sort by expression.  The expression is going to be:

=match(DimensionField,'Offered/Hired','Hiring Team Interview','HR/Tech Screening','New Applicant')

The match function returns the number in the list where the dimension value is found.  For example Offered/Hired will return a 1 and HR/Tech Screening will return a 3.  This should allow you to sort the graph in the way you order your match list.

Karl

View solution in original post

Highlighted
Not applicable

Thanks!  Match() worked well.  Yeah, I'm aware I could assign values to them... But my client has a static Excel file, doesn't want to be touched.