Sort Order of a pivot table dimension

[#1]

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.

[#2]

Maybe the answer would invlove load order too.

[Sokkorn]

Hi Brandon,

It is possible to upload your app and requirement?

Regards,

Sokkorn

[#4]

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