Summing to Specific Columns in Different Fields

jordanc — Sat, 16 Nov 2024 04:32:29 GMT

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.

Re: Summing to Specific Columns in Different Fields

NW1965 — Wed, 20 Feb 2019 10:51:33 GMT

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.

topic Summing to Specific Columns in Different Fields in QlikView

Summing to Specific Columns in Different Fields

Re: Summing to Specific Columns in Different Fields