how to sort by expression for a calculated dimension?

[jim_chan]

Hi guys, 

I have created a sample qvw file for my scenario. my problem, i cant sort by expression a calculate dimension.

my calculated dimension is:

=if(Match(cat,'bread','flour','others'),'others',cat)

then i tried to SORT BY expression:

MATCH(cat,'meat','vege','others')

my expected result:

the sorting in the table should be meat, vege,others. i couldnt get this result.

Can you guys help me out?

Rgds

Jim

[jim_chan]

sorry,the attachment!

[sergio0592 · Accepted solution]

Hi,

You can create another calculated dimension with:

MATCH(if(Match(cat,'bread','flour','others'),'others',cat),'meat','vege','others')

Sort on this dimension (Numeric Value/Ascending) and hide this dim in presentation tab.

See the attached .qvw

[riceball]

Try: Sort expression = MATCH('meat','vege','others'). Remove the "cat"

[jim_chan]

thanks bro, is helpful!