Below is my data set
Load * Inline [
Simple Pivot is my result
Sum of Score is my measure
Need to display '0' in the null place in pivot chart
By 'yourExpression' i think you mean the measure? If i got it properly it dint work too. Can you elaborate
You are right, I tested it and it did not work. I guess the problem is, that the null-fields are combinations of the two dimensions that do not exists in the data model. Therefore Qlik is not even calculating anything and therefore the coalesce function is not even applied.
To make the coalesce function work you would have to make sure that all the combinations exist in the datamodel. Score can even be null() to not affect any avg() expression.
So you would have to make a full join for the dimensions and concatenate those new lines to your table.
But you already have a script-related solution and I am right now not aware of a front-end-only solution. sorry!