topic Sort Order of a pivot table dimension in QlikView

Sort Order of a pivot table dimension

Thu, 10 May 2012 21:18:53 GMT

Hi community,

I think I got an easy one here. I have a dimension that has a loaded field with 4 possible names as its values. How can I set the sort order however I want to. Probably involves sort by expression and an inline load of the names in that table.

Sort Order of a pivot table dimension

Thu, 10 May 2012 21:20:03 GMT

Maybe the answer would invlove load order too.

Sort Order of a pivot table dimension

Sokkorn — Fri, 11 May 2012 01:33:21 GMT

Hi Brandon,

It is possible to upload your app and requirement?

Regards,

Sokkorn

Sort Order of a pivot table dimension

Fri, 11 May 2012 03:37:30 GMT

Hi,

there are many ways to sort your data...

but if the choices in qlikview sort can't make your requirements

then you can force it by using match function.

Example:

go to sort tab > under Expression - set to Ascending

say I have a CATEGORY table with FOOD, MERCHANDIZE, and BEVERAGE as data

using match function I can force it to sort in anyway I want with this syntax

Match(TableName, 'First data', 'Second',...)

in my case:

Match(CATEGORY,'FOOD','BEVERAGE','MERCHANDIZE')

this will result to

CATEGORY - Table name

FOOD

BEVERAGE

MERCHANDIZE

Regards,

Alex