New to Qlik Analytics

If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!

Who Me Too'd this solution

sunny_talwar

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')

 

View solution in original post

Who Me Too'd this solution