Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
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