I am new to QlikView and I have the below expression that surprisingly works on QV Server but doesn't work on my local. I have the same datasets on local and server (i.e. all the fields that are used in this calculation is available in both places with appropriate data).
If you used a table-chart for the expression and leave the label empty you could see there how the expression is evaluated. If you compared this on both sides I think you will find the differences between them.