Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sort Order of a pivot table dimension

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.

3 Replies
Not applicable
Author

Maybe the answer would invlove load order too.

Sokkorn
Master
Master

Hi Brandon,

It is possible to upload your app and requirement?

Regards,

Sokkorn

Not applicable
Author

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