Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
qlikwiz123
Creator II
Creator II

Sum of Rows in a Text Box

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

1 Solution

Accepted Solutions
qlikwiz123
Creator II
Creator II
Author

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.

View solution in original post

6 Replies
MK_QSL
MVP
MVP

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

Can you provide dimensions and expressions here?

john_obrien
Contributor III
Contributor III

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
Creator II
Creator II
Author

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
MVP
MVP

You can use something like this

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

Add all your dimensions inside aggr.

MK_QSL
MVP
MVP

You selected your answer as correct???

shiveshsingh
Master
Master

Strange