topic How to group and SUM values in QlikView

How to group and SUM values

Anonymous — Fri, 24 Jan 2014 14:26:23 GMT

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.

Re: How to group and SUM values

Nicole-Smith — Fri, 24 Jan 2014 14:35:50 GMT

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.

Re: How to group and SUM values

puttemans — Fri, 24 Jan 2014 14:37:21 GMT

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.

Re: How to group and SUM values

Anonymous — Fri, 24 Jan 2014 14:40:51 GMT

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

Re: How to group and SUM values

Anonymous — Fri, 24 Jan 2014 14:53:18 GMT

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

Re: How to group and SUM values

Nicole-Smith — Fri, 24 Jan 2014 14:59:43 GMT

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