Sum only containing defined units

JonasM95 — Thu, 31 Jan 2019 09:57:57 GMT

Hi everybody,

I am working on a Pivot Table that contains production output for several working places. Some working places are reporting different quantity units (for example pieces as well as kg). For that reason I have a source that links a working place with its desired unit.

Unfortunately I am not able to formulate a sum that only adds output entrys if their quantity unit matches the defined one.

=Sum({$<PROD.PMEIN = {$(PM2_0.VME)},PROD.PRODDAT2 = {"<=$(=num(Stichtag))"}>} PROD.GMNG_PRDME)

PM2_0.VME --> desired quantity unit (VME Soll)

PROD.PMEIN --> quantity unit in output entry (VME, concat seperated by '|' if more than one)

PROD.GMNG_PRODME --> output quantity (Output Ist should not be 0)

The tables PROD and PM2_0 are linked with a key. Second condition is working perfectly.

Can anyone recognize my mistake? Please help!!

Best regards

Jonas

Re: Sum only containing defined units

agigliotti — Thu, 31 Jan 2019 10:13:52 GMT

try this:
=Sum( {< PROD.PRODDAT2 = {"<=$(=num(Stichtag))"} >}
if( PROD.PMEIN = PM2_0.VME, PROD.GMNG_PRDME ) )

Re: Sum only containing defined units

JonasM95 — Thu, 31 Jan 2019 10:21:07 GMT

Thanks a lot for your quick reply, I have just tested and it seems to work.

Never thought that the solution would be so easy.

topic Sum only containing defined units in QlikView

Sum only containing defined units

Re: Sum only containing defined units

Re: Sum only containing defined units