topic Re: RE: Total sum of rows in App Development

RE: Total sum of rows

Chanty4u — Wed, 22 Dec 2021 20:40:09 GMT

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

Re: RE: Total sum of rows

Gysbert_Wassenaar — Mon, 14 Mar 2016 12:44:51 GMT

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

sunny_talwar — Mon, 14 Mar 2016 12:45:44 GMT

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

Chanty4u — Mon, 14 Mar 2016 12:55:15 GMT

how can we give the sum(x) value?

Re: RE: Total sum of rows

Chanty4u — Mon, 14 Mar 2016 12:55:44 GMT

avg of that 3rows means

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

Re: RE: Total sum of rows

Chanty4u — Mon, 14 Mar 2016 13:09:23 GMT

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

Gysbert_Wassenaar — Mon, 14 Mar 2016 13:12:09 GMT

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

Chanty4u — Mon, 14 Mar 2016 13:16:50 GMT

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

Re: RE: Total sum of rows

Chanty4u — Mon, 14 Mar 2016 13:18:29 GMT

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

sunny_talwar — Mon, 14 Mar 2016 13:18:50 GMT

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

Re: RE: Total sum of rows

sunny_talwar — Mon, 14 Mar 2016 13:20:36 GMT

May be this:

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

Re: RE: Total sum of rows

Chanty4u — Mon, 14 Mar 2016 13:24:26 GMT

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

Re: RE: Total sum of rows

sunny_talwar — Mon, 14 Mar 2016 13:28:34 GMT

Try this:

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

Re: RE: Total sum of rows

Chanty4u — Mon, 14 Mar 2016 14:59:05 GMT

thnk q sunny..

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

Please suggest fror the solution

Re: RE: Total sum of rows

sunny_talwar — Mon, 14 Mar 2016 15:04:01 GMT

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

Chanty4u — Mon, 14 Mar 2016 15:09:45 GMT

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

Chanty4u — Tue, 15 Mar 2016 05:00:29 GMT

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?

Re: RE: Total sum of rows

Chanty4u — Tue, 15 Mar 2016 05:47:35 GMT

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?

Re: RE: Total sum of rows

Gysbert_Wassenaar — Tue, 15 Mar 2016 06:32:03 GMT

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

sunny_talwar — Tue, 15 Mar 2016 08:13:03 GMT

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