How to group and SUM values

[Anonymous]

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.

[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]

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]

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

[Anonymous]

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