Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
mahendragaur
Contributor

Custom Sort not working

I am trying below expression to custom sort value but it is not working. Any suggestion please

Match(Dim,'Car','Bus','Plane','Boat')

Labels (1)
2 Replies
anushree1
Valued Contributor II

Re: Custom Sort not working

Hi,

Please check the attachment, it seems to work for me

vijetasharma
Valued Contributor

Re: Custom Sort not working

=Match(Dim,'Car','Bus','Plane','Boat')this should work if not, you can use if condition like below,

if(Dim='Car',1,if(Dim='Bus',2,if(Dim='Plane',3,if(Dim='Boat',4))))

Regards,

Vijeta