topic Re: Custom Ordering in QlikView

Custom Ordering

Thu, 13 Feb 2014 15:58:32 GMT

INFORMATION IN THIS FILE IS FICTITOUS

Attached is a .qvw FILE

This is a pivot table. How can I custom order MGMM, PPGM, PRGM (Within Job COLUMN) to display in the following order:

PPGM PRGM MGMM

jerem1234 — Thu, 13 Feb 2014 16:01:22 GMT

You can use this expression for sorting on your Job dimension under the Sort tab:

match(Job, 'PPGM', 'PRGM', 'MGMM')

Hope this helps!

MK_QSL — Thu, 13 Feb 2014 16:03:19 GMT

Go to sort tab

Select Job

Under expression type below and select Ascending

Match(Job,'PPGM','PRGM','MGMM')

Nicole-Smith — Thu, 13 Feb 2014 16:03:22 GMT

alexandros17 — Thu, 13 Feb 2014 16:06:19 GMT

In the sort tab click Job, uncheck ordering by text and check expression (set ascending) and write in it:

if(Job='PPGM',1, if(Job='PRGM',2,3))

Hope it helps

Thu, 13 Feb 2014 16:46:14 GMT

Thank you for taking time respond. this option works too.

Thu, 13 Feb 2014 16:46:32 GMT

Thank you for taking time to respond. This option works too.

Thu, 13 Feb 2014 16:46:53 GMT

Thank you for taking time to respond, this option works

Thu, 13 Feb 2014 16:47:07 GMT

Thank you for taking time to respond this option works.

Thu, 13 Feb 2014 17:35:33 GMT

yes, match function is very helpful when you have specific sort order for limited no. of field values