topic Re: Custom Sort not working in QlikView

Custom Sort not working

mahendragaur — Sat, 16 Nov 2024 21:37:03 GMT

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

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

anushree1 — Fri, 11 Jan 2019 07:54:37 GMT

Hi,

Please check the attachment, it seems to work for me

vijetas42 — Fri, 11 Jan 2019 08:03:19 GMT

=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