How to add all rows of a particular column, i just need the syntax.
total - 15.
How do i achieve that using expressions in qlik view.
Need help on a urget basis.
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 [A12345]; load sum(A) as TotalA resident Temp;
LOAD * INLINE [
I hope it helps,
I need to sum this in a expression, how do i do this?
Create a pivot table. Add "A" as dimension and in the expression tab write "sum(A)"
i need to sum all rows in a particular dimension, how do i do that?
Use =Sum(A) in a Text Object.
Go to Presentation tab-->Select Dimension -->Check Partial sums,It will give you the sum of all rows.
Hope it helps...
I cannot find this option, in which object can i find this?
You can find that option in pivot table.
Retrieving data ...