Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

try :

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

Regards