Sort Order

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am using the below expression in sorting the values , but when certain sections are made the values changes its order,

How do i keep this sorting fixed .

=if(UAP_Release_ID='18.1',1 ,if(UAP_Release_ID='18.2',2,if(UAP_Release_ID='18.3',3,if(UAP_Release_ID='18.4',4,if(UAP_Release_ID='18.5',5,if(UAP_Release_ID='18.6',6,
if(UAP_Release_ID='18.7',7,if(UAP_Release_ID='18.8',8,if(UAP_Release_ID='18.9',9,if(UAP_Release_ID='18.10',10,if(UAP_Release_ID='18.11',11,if(UAP_Release_ID='18.12',12,
if(UAP_Release_ID='18.01',13,if(UAP_Release_ID='18.02',14,if(UAP_Release_ID='18.03',15,if(UAP_Release_ID='18.04',16,if(UAP_Release_ID='18.05',17,if(UAP_Release_ID='18.06',18,
if(UAP_Release_ID='18.07',19,if(UAP_Release_ID='18.08',20,if(UAP_Release_ID='18.09',21,if(UAP_Release_ID='18.010',22,if(UAP_Release_ID='18.011',23,if(UAP_Release_ID='18.012',24
))))))))))))))))))))))))

Re: Sort Order

Gysbert_Wassenaar — Mon, 10 Dec 2018 11:26:01 GMT

try somehting like this instead: match(only({1}UAP_Release_ID), '18.1','18.2', ...etc... ,'18.012'))

topic Sort Order in QlikView

Sort Order

Re: Sort Order