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