Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

jazzsran
New Contributor II

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
New Contributor II

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

Hi Jaspreet Sran

maybe you could use aggr() function like this :

aggr(sum(A*B),Dimension)

3 Replies
lucpechali
New Contributor II

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

Hi Jaspreet Sran

maybe you could use aggr() function like this :

aggr(sum(A*B),Dimension)

greeshma_k
Contributor III

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

try sum(A*B)

jazzsran
New Contributor II

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

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

Community Browser