Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Expression total vs sum of row

Hello;

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.

Many thanks.

Kristel.

1 Reply
Not applicable

Re: Expression total vs sum of row

try :

sum(aggr(ur current expression),Dimension1,Dimension2,..Dimension n)

Regards

Community Browser