# New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Contributor

## Set Analysis - Only Associated Data From Another Field?

Hello,

I'm pretty new to QV, and very new to set analysis.

Sum({\$<[Cost Elem._COST_ELEM.FAGLFLEXA] = '90360100' and [Cost Ctr_KOSTL.BSEG] = {*} - {' '}>} Values)

I want to sum [Values] where [Cost Elem._COST_ELEM.FAGLFLEXA] = ‘90360100’ AND (+?) only [Cost Ctr_KOSTL.BSEG]’s relevant (associated) values are selected. There’s a one to many relationship between Cost Elem and Cost Ctr (1 cost elem to many cost ctrs) when a cost elem is selected. Is it even possible to just select the associated cost ctrs? Should I just list them out instead? The expression box bug won't compile/validate the rest of the expression for me. I want to make sure it’s good 1st because I have others to write based off of it.

1 Solution

Accepted Solutions
Partner

## Re: Set Analysis - Only Associated Data From Another Field?

Sum({\$<[Cost Elem._COST_ELEM.FAGLFLEXA] = {90360100}, [Cost Ctr_KOSTL.BSEG] -=  {' '}>} Values)

3 Replies
Partner

## Re: Set Analysis - Only Associated Data From Another Field?

Sum({\$<[Cost Elem._COST_ELEM.FAGLFLEXA] = {90360100}, [Cost Ctr_KOSTL.BSEG] -=  {' '}>} Values)

Not applicable

## Re: Set Analysis - Only Associated Data From Another Field?

Hi,

Try this

Sum({\$<[Cost Elem._COST_ELEM.FAGLFLEXA] = {90360100}, [Cost Ctr_KOSTL.BSEG] = {*} - {' '}>} Values)

Contributor

## Re: Set Analysis - Only Associated Data From Another Field?

Will report my findings and will be sure to credit the responses as correct when I find out. Thanks a lot for your help you guys.