Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Try this
=Match(Pick(Dim, [Sex], [Offence Group (Q)], [Race/Ethnicity Group (G)]), 'Male', 'Female', 'Intersex', 'Other', 'Prefer not to say', 'White', 'Black/Black British', 'Asian/Asian British', 'Mixed', 'Arab or Other', 'Unknown/Not stated')