Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

sum of all row values in a column

i am using a straight table in that i need to sum all the values in a column i.e..,if i have values 10,20,30,40 in a column   i need sum(10,20,30,40) i.e.., 100 to repeat in other column could any one help out me to write the expression for that.

Thank you

15 Replies
sunny_talwar

Try using RangeSum()

Eg: RangeSum(Exp1, Exp2, Exp3, Exp4)

maxgro
MVP
MVP

you can use the same expressions

if expression for lablel1 column is    sum(Expression2), for label 2   sum(Expression2), ......

sum(Expression1) + sum(Expression2) + sum(Expression3)

or you can use the label name as in image

label1 + label2 + label3

1.png

Not applicable
Author

Tq sunny

But Its not working..,

Not applicable
Author

i have only one expression and i want to repeat the sum of that expression in second expression..

1st expression                    2nd expression

10                                            100

20                                            100

30                                            100

40                                            100

Not applicable
Author

I think u can understood some what better by seeing this

i have only one expression and i want to add 2nd expression to my straight table  which  repeats the sum of row values in 1st  column .

1st expression                    2nd expression

10                                            100

20                                            100

30                                            100

40                                            100

Thank you

sunny_talwar

Let say your first expression is Sum(Sales). Add the second expression as Sum(TOTAL Sales)

maxgro
MVP
MVP

maybe using Total

or post the 1 st expression

Not applicable
Author

sum(costinpatient)/count(Distinct membnr).

sunny_talwar

May be this:

Sum(TOTAL Aggr(Sum(costinpatient)/Count(DISTINCT membnr), YourChartDimensions))