Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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