Re: How does AGGR function exactly work in case of missing values?
Thank you Stefan,
This is the kind of answer that I was hoping for. The ID and Year is linked to both EBIT and Turnover in exactly same way, they are just 2 different values in 2 different columns (simplified explanation).
The problem here however is that it still does not explain my problems that I am experiencing with the further use of this function.
I am actually using this further in my calculation to calculate upper, lower fractile and median out of those values. And what I am experiencing is that an extension for boxplots (I am forced to use an extension as the native QlikSense boxplot does not offer an option to add one more linear measure to the chart) simply shows different values for these once there are missing values than a simple KPI measure.
The difference in calculation is that for boxplot I simply calculate the Aggr and let the chart do the outer function in terms of calculating min,max,median,lower and upper Q. And for KPI I do manually calculate Fractile(aggr function, 0.25) etc..
Picture showing same results, no missing value in any of the observation,
Picture showing different results, missing values have been in some of the observations