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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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))