Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Create a pivot table. Add "A" as dimension and in the expression tab write "sum(A)"
I need to sum this in a expression, how do i do this?
i need to sum all rows in a particular dimension, how do i do that?
Hi,
Use =Sum(A) in a Text Object.
Celambarasan
Hi,
Go to Presentation tab-->Select Dimension -->Check Partial sums,It will give you the sum of all rows.
Hope it helps...
Sivaraj
I cannot find this option, in which object can i find this?
Hi
You can find that option in pivot table.
Celambarasan