Need help with a formula

[greenyTBD]

Hi,

I'm new to Qlik and need some help with a formula for a table.

I am trying to get the formula that gives me the numbers in column D.

Any idea if this would work dynamically in qlik?

 

Any help is greatly appreciated,

Thanks

[vinieme12 · Accepted solution]

1) if the column SUM is a measure, let say

SUM = sum(Value)

Then  use below

Max(TOTAL <Inventory> Aggr(sum(Value),Inventory,Color)) - sum(Value)

2) If the column SUM is not an aggregated measure

=SUM

then use below

=Max(TOTAL <Inventory>  SUM) - SUM

[greenyTBD]

Perfect, first one worked right away.

Thank you very much! You helped me alot