Solved: Re: RE: Total sum of rows - Qlik Community

Chanty4u · ‎2016-03-14

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

sunny_talwar · ‎2016-03-15

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

Gysbert_Wassenaar · ‎2016-03-14

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 · ‎2016-03-14

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 · ‎2016-03-14

how can we give the sum(x) value?

Chanty4u · ‎2016-03-14

avg of that 3rows means

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

Chanty4u · ‎2016-03-14

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?

Gysbert_Wassenaar · ‎2016-03-14

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 · ‎2016-03-14

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

Chanty4u · ‎2016-03-14

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 · ‎2016-03-14

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