Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to find Avg and Total.

Hi Folks,

I have student table, in this table have

hltno,sno, m1, m2, m3 fields

I need to find out avg and also total

Form back-end and front end of each student wise.

Tags (1)
1 Solution

Accepted Solutions

Re: How to find Avg and Total.

In frontend ..

Add hltno,sno, m1, m2, m3 as dimension and in the expression

Total: sum(m1)+sum(m2)+sum(m3) --- this will give the total

Avg: AVG(m1+m2+m3) or (sum(m1)+sum(m2)+sum(m3))/3 ------ as you have 3 subjects

3 Replies

Re: How to find Avg and Total.

In frontend ..

Add hltno,sno, m1, m2, m3 as dimension and in the expression

Total: sum(m1)+sum(m2)+sum(m3) --- this will give the total

Avg: AVG(m1+m2+m3) or (sum(m1)+sum(m2)+sum(m3))/3 ------ as you have 3 subjects

amit_saini
Honored Contributor III

Re: How to find Avg and Total.

Hi,

u can use these settings while you have data in charts.

Thanks,

AS

Not applicable

Re: How to find Avg and Total.

Total: sum(m1)+sum(m2)+sum(m3) --total

Avg: AVG(m1+m2+m3);

Community Browser