Sum of Rows in a Text Box

[qlikwiz123]

How do I get Sum of Rows value on a Expression/Field from Straight Table in a Text Box?

[MK_QSL]

It depends on what dimensions and expressions you are using in your straight table.

Can you provide dimensions and expressions here?

[john_obrien]

QW,

You could use the aggr() function inside a sum() to get the same result as a sum of rows in a table.  The aggr() would calculate the expression for each combination of dimension values - just like straight table does.

I hope that helps.

[qlikwiz123 · Accepted solution]

The Expression is a simple Count(Field) but there are many dimensions in the Straight Table. Should I list all the dimensions under Aggr() ? I don't show all the Dimensions at once. What happens then.

[MK_QSL]

You can use something like this

SUM(Aggr(Count(Field),Dim1,Dim2,Dim3))

Add all your dimensions inside aggr.

[MK_QSL]

You selected your answer as correct???

[shiveshsingh]

Strange