Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to group and SUM values

How do I group the values in the following table to add together values A - H to provide a SUM total for the ethncities that are white.  I don't want to show the full breakdown as shown below.  I want to group some of the values.

ethnicity.bmp

5 Replies
Nicole-Smith

For your dimension, you could use something like this:

pick(wildmatch(YourEthnicityField, '*White*', '*Scottish*'), 'White', 'Scottish')

This will group anything with the word White in it under a simple 'White' label (the same goes for the second Scottish part).  Just keep adding to the calculation until you have all of your desired values.

puttemans
Specialist
Specialist

Hi,

Is it possible to create a new variable, based upon the ethnicity information, that identifies each 'master' type of ethnicity?

Then by reporting that variable the way you did in your table, you'll have the sum.

Anonymous
Not applicable
Author

Hi - Not easily.  I would prefer to do something at the Qlikview end.

Anonymous
Not applicable
Author

Thanks.  How do I then SUM the ones that have white in the value?

Nicole-Smith

You should be able to use the same sum function you were before (for what you have pictured in your original post).