Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
jazzsran
Partner - Contributor III
Partner - Contributor III

How to get 'Sum of Rows' in Text box instead of 'Expression Total' ?

Hi all,

I have a Text Box to display the value for an expression like sum(A)*B, for any number of dimensions selected by the user.

By default it is showing 'Expression Total', which is not giving correct results because of multiplication involved.

I need to show 'Sum of the Rows' in the same.

Data example :

DimensionAB
D1102
D2123
D3134

If D1, D2 and D3 are selected,

Expression Total:   (10+12+13) * (2+3+4) = 35 * 9 = 315 (incorrect)

Sum of Total: (10*2)+(12*3)+(13*4) = 108 (correct)

Can anyone suggest a solution?

Thanks in advance

1 Solution

Accepted Solutions
lucpechali
Partner - Contributor III
Partner - Contributor III

Hi Jaspreet Sran

maybe you could use aggr() function like this :

aggr(sum(A*B),Dimension)

View solution in original post

3 Replies
lucpechali
Partner - Contributor III
Partner - Contributor III

Hi Jaspreet Sran

maybe you could use aggr() function like this :

aggr(sum(A*B),Dimension)

Anonymous
Not applicable

try sum(A*B)

jazzsran
Partner - Contributor III
Partner - Contributor III
Author

Hi Luc,

yes, you are right, just need to add sum outside this to get sum for all the dimensions.

sum(aggr(sum(A*B),Dimension))

Thanks,

Jaspreet Kaur Sran