Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
merry2018
Creator III
Creator III

Value from Part A show at Part B

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

Labels (2)
0 Replies