Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
jordanc
New Contributor II

Summing to Specific Columns in Different Fields

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.

Capture.PNG

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

1 Solution

Accepted Solutions
NW1965
Contributor

Re: Summing to Specific Columns in Different Fields

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.

 

1 Reply
NW1965
Contributor

Re: Summing to Specific Columns in Different Fields

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.