Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
MVP
MVP

RE: Total sum of rows

Hi all,

settu_periasamy

i have stright table in my Qliksense app.

so i have  one dimension

3 measures

so i want to  get the  avg total of  that three rows   ?

is this posible?

Thanks in advance

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

I think gysbert is right that, I don't see how this can be done dynamically, but if you know the upper limit to the number of expressions that you might have, you can add them to the below expression:

RangeAvg(Column(1), Column(2), Column(3), Column(4), Column(5), Column(6), ......)

View solution in original post

23 Replies
Gysbert_Wassenaar

If you want the average of the outcomes of the measures you can use the rangeavg function: rangeavg( sum(X), sum(Y), sum(Z) )

if you want the average of the outcomes for three dimension values you can use something like avg(total aggr(sum(X),DimensionA))


talk is cheap, supply exceeds demand
sunny_talwar

Can you elaborate on the following

"avg total of that three rows"

Which 3 rows? where do you want to get the total? in a KPI object? on the chart itself?

Chanty4u
MVP
MVP
Author

how can we give the sum(x)  value?

Chanty4u
MVP
MVP
Author

avg of that 3rows means

i hve three measures na so  i need  those sum of avg?

Chanty4u
MVP
MVP
Author

hi ,

plz chk image   and how to get the expresion?

above i have oe dimension 3measures  and i want avg  of that total?

how can i write exp?sense-piv.png

Gysbert_Wassenaar

i want avg  of that total?

I don't know if you want that. I don't even know what total you're talking about.


talk is cheap, supply exceeds demand
Chanty4u
MVP
MVP
Author

i mean  the  three measures row wise  sum ?  and  avg of that three measures

Chanty4u
MVP
MVP
Author

in abve  image

yearsalry+count+office=total    of frst row   2nd row 3rd row and then avf of all

60000+1+2=60003  

sunny_talwar

Why don't you share a sample and let us know what your expected output is?