Value from Part A show at Part B

merry2018 — Fri, 04 Mar 2022 07:37:59 GMT

Hello Together,

I need yout help again for a Problem.

I would like aggregar the Value from Part A to Part B, show like this:

Part	Original_Value	Shifted_Value	Total_Shift
A	15	0	15
B	23	15	38

My idea for the solve (Total_Shift) was:

if(Part = B, sum({<Part={'A'}>}Original_Value) + sum(Orginal_Value), sum(Orginal_Value) ) And for the Shifted_Value I tried: if(Part = B, sum({<Part={'A'}>}Original_Value), 0 )

But I get only for the Part A the Values, not the other One.

Best Regards
Merry

topic Value from Part A show at Part B in QlikView

Value from Part A show at Part B