Discussion Board for collaboration related to Creating Analytics for QlikView.
I am working with a straight table including a complex expression with many IF statements.
The result per line of these IF statements is correct.
In the straight table I can activate the Sum of Row function to get to the required total for these IF statements.
When trying to get to the expression total I am confronted with the fact that the total returned is always 1 or -.
What is so special about this function Sum of Row.
What need to be used in an expression to get to the sum of IF statement similar to what the Sum of Row is returning.
Hope you can guide me.
sum(aggr(ur current expression),Dimension1,Dimension2,..Dimension n)