ordering multiple field values

[ajlptnhs]

Hello,

I am currently creating a pick dim pivot table, in Qlik sense.

I have managed to bring in dimensions and measures. however, I want to be able to ordering the fields I am bringing in, in a particular order.

For example, I have the following fields picked :

Gender

Offence Group

Ethnicity Group

with the following values within the fields:

Gender: Female, Male

Offence Group: Drugs, theft, Robbery, Fraud

Ethnicity Group: Asian, Black, Mixed, White

I want to be able to order each field, in a particular order, usually alphabetically.

I've tried using wilmatch, like below:

wildMatch([Ethnicity Group],'White','Black/Black British',
'Asian/Asian British','Mixed','Arab or Other','Unknown/Not stated',

wildmatch([Gender],'Male','Female'
))

the ethnicity bit works, but the Gender bit of the formula, isn't changing.

Can anyone help, or have an alternative option I can use ?

as I have over 20+ fields to change the orders for.

Thanks

Ajay

[ajlptnhs]

that's brilliant, thank you so much for your help.