topic Need help in syntax in QlikView

Need help in syntax

Wed, 14 Mar 2012 09:19:46 GMT

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

For eg,

---

total - 15.

How do i achieve that using expressions in qlik view.

Need help on a urget basis.

eliran — Wed, 14 Mar 2012 09:32:10 GMT

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 — Wed, 14 Mar 2012 09:41:47 GMT

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

Wed, 14 Mar 2012 09:43:25 GMT

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

Wed, 14 Mar 2012 09:47:30 GMT

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

CELAMBARASAN — Wed, 14 Mar 2012 10:20:25 GMT

Hi,

Use =Sum(A) in a Text Object.

Celambarasan

sivarajs — Wed, 14 Mar 2012 10:21:23 GMT

Hi,

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

Hope it helps...

Sivaraj

Wed, 14 Mar 2012 11:17:04 GMT

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

CELAMBARASAN — Wed, 14 Mar 2012 11:32:43 GMT

You can find that option in pivot table.

Celambarasan