Show aggregate function result over null values in table

[Tim_G]

Hello there,

I was wondering if (how) one could hide null value rows in a table BUT still use a function on a measure in another column over all (also the null) rows. Here is an example:

In this case I want to display only not null values in the "Location" column but still the MAX() function on "Special stock qty", thus that we only have one row per Product_ID and Date, showing Location 1450 and qty 2.

If we disable "Include null values" in the Location field, then the qty is 0 beacuse the 2 row is also dropped. 

Any ideas on that? Sure I could manipulate the raw data, but I would love a dynamic solution using Qlik functions.

Kind Regards,

Tim