Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Creator II
Creator II

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

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

Can you provide dimensions and expressions here?

Highlighted
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.

Highlighted
Creator II
Creator II

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

Highlighted
MVP
MVP

You can use something like this

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

Add all your dimensions inside aggr.

Highlighted
MVP
MVP

You selected your answer as correct???

Highlighted
Master
Master

Strange