Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
rpayn01215
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
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
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)

rpayn01215
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.