Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need help in syntax

How to add all rows of a particular column, i just need the syntax.

For eg,

A

---

1

2

3

4

5

---

total - 15.

How do i achieve that using expressions in qlik view.

Need help on a urget basis.

1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Use =Sum(A) in a Text Object.

Celambarasan

View solution in original post

8 Replies
eliran
Creator III
Creator III

Hey,

I'm not sure what you need it for, but one option is to re-load the table using aggr function as sum.

Temp:

LOAD * INLINE [

A

1

2

3

4

5

];

load sum(A) as TotalA
resident Temp;

I hope it helps,

Eliran.

jvitantonio
Luminary Alumni
Luminary Alumni

Create a pivot table. Add "A" as dimension and in the expression tab write "sum(A)"

Not applicable
Author

I need to sum this in a expression, how do i do this?

Not applicable
Author

i need to sum all rows in a particular dimension, how do i do that?

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Use =Sum(A) in a Text Object.

Celambarasan

sivarajs
Specialist II
Specialist II

Hi,

Go to Presentation tab-->Select Dimension -->Check Partial sums,It will give you the sum of all rows.

Hope it helps...

Sivaraj

Not applicable
Author

I cannot find this option, in which object can i find this?

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi

You can find that option in pivot table.

Celambarasan