Summing to Specific Columns in Different Fields

[jordanc]

Hi there,

I am fairly new to QlikView and so I apologize in advance if I have the incorrect name for certain items.  I am trying to add two columns that are under different fields in 'Expression' section of a Chart object.  I have included a picture to illustrate what I am trying to do.  I am trying to take the values in Group A>SubGroup i and add them to the values in Group B>SubGroup v.  I want to keep the column Group B>SubGroup v and drop GroupA>SubGroup i.

Thanks in advance, and I apologize again if this is a difficult question to answer.

[NW1965 · Accepted solution]

Should be relatively straight forward using Set Analysis in your expressions but before I suggest a solution could you provide a quick picture of the output you'd like to see.