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
