22 Replies Latest reply: Mar 15, 2016 4:48 AM by Chanty 4u

# 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?

• ###### Re: RE: Total sum of rows

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))

• ###### Re: RE: Total sum of rows

how can we give the sum(x)  value?

• ###### Re: RE: Total sum of rows

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?

• ###### Re: RE: Total sum of rows
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.

• ###### Re: RE: Total sum of rows

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

• ###### Re: RE: Total sum of rows

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

• ###### Re: RE: Total sum of rows

may i know the path of our working qvf?  i frgt sunny

• ###### Re: RE: Total sum of rows

Try this:

C:\Users\YourUserID\Documents\Qlik\Sense\Apps

• ###### Re: RE: Total sum of rows

thnk q sunny..

PFA for my qvf    in new sheet  i hve pivot table?

• ###### Re: RE: Total sum of rows

Is this what you are looking for?

Used this expression:

RangeAvg(Sum(year), Sum([Year Salary]), Min([Year Salary]))

• ###### Re: RE: Total sum of rows

thnks sunny,

i need that  am sure..but  i need to chk with original data  tommorw and come back to u

• ###### Re: RE: Total sum of rows

Hi sunny,

Sunny T

The solution which u hve provided is correct.  But  is it posible to do dynamically?

i mean if we hve 3 measures  so we simply used that in expression  in future  we will get more measures?

So how can i do this?

• ###### Re: RE: Total sum of rows

You mean that the number of the expression might increase from 3 or the names might change?

• ###### Re: RE: Total sum of rows

yes sunny exctlty....

• ###### Re: RE: Total sum of rows

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), ......)

• ###### Re: RE: Total sum of rows

Ok sunny. Let me try and let u knoow.

Thanks again.

• ###### Re: RE: Total sum of rows

in abve  image

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

60000+1+2=60003

• ###### Re: RE: Total sum of rows

May be this:

Avg(Aggr(yearsalry+count+office, EmpID))

• ###### Re: RE: Total sum of rows

but  how to use dynamically?

i mean if we hve 3 measures  so we simply used that in expression  in future  we will get more measures?

• ###### Re: RE: Total sum of rows

It cannot be done dynamically. Measures are not created dynamically. If you add a measure to your chart you have to do that dynamically. And you will have to change the rangeavg measure manually after you manually added a new measure to your chart.

• ###### Re: RE: Total sum of rows

thnx bro...

is there any other alternate for this?

• ###### Re: RE: Total sum of rows

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?

• ###### Re: RE: Total sum of rows

avg of that 3rows means

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