topic Re: How to find Avg and Total. in QlikView

How to find Avg and Total.

Tue, 09 Feb 2016 02:07:38 GMT

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.

avinashelite — Tue, 09 Feb 2016 06:26:59 GMT

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 — Tue, 09 Feb 2016 06:44:33 GMT

Hi,

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

Thanks,

Tue, 09 Feb 2016 06:46:51 GMT

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

Avg: AVG(m1+m2+m3);