topic Set Analysis - Only Associated Data From Another Field? in QlikView

Set Analysis - Only Associated Data From Another Field?

Anonymous — Tue, 25 Nov 2014 18:25:40 GMT

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 1^st because I have others to write based off of it.

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

simenkg — Tue, 25 Nov 2014 18:33:44 GMT

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

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

Tue, 25 Nov 2014 18:37:23 GMT

Hi,

Try this

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

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

Anonymous — Tue, 25 Nov 2014 18:45:39 GMT

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.