topic Re: how to sort by expression for a calculated dimension? in QlikView

how to sort by expression for a calculated dimension?

jim_chan — Sat, 16 Nov 2024 03:18:55 GMT

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 — Thu, 13 Jun 2019 09:23:27 GMT

sorry,the attachment!

sergio0592 — Thu, 13 Jun 2019 09:37:24 GMT

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 — Thu, 13 Jun 2019 09:45:29 GMT

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

jim_chan — Thu, 13 Jun 2019 10:27:16 GMT

thanks bro, is helpful!