RE: Total sum of rows

[Chanty4u]

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]

May be this:

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

[Chanty4u]

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

[sunny_talwar]

Try this:

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

[Chanty4u]

thnk q sunny..

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

Please suggest fror the solution

[sunny_talwar]

Is this what you are looking for?

Used this expression:

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

[Chanty4u]

thnks sunny,

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

[Chanty4u]

Hi sunny,

sunindia

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?

[Chanty4u]

thnx gwassenaar

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?

[Gysbert_Wassenaar]

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.

[sunny_talwar]

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