topic Re: AVG FUNCTION in QlikView

AVG FUNCTION

Fri, 06 Jun 2014 10:26:32 GMT

I am new to qlikview can any one suggest me how to bring Avg in qlikview

My requiremnet is as below

GRP	Apr-13	May-13	Jun-13	Jul-13	Aug-13	Sep-13	Oct-13	Nov-13	Dec-13	Grand Total	AVG
A	971	1145	983	942	882	931	1005	970	970	8799	978
B	903	763	1055	859	812	673	592	364	364	6385	709
C	708	875	742	653	591	703	600	889	889	6650	739
D	0	0	0	0	0	296	224	42	42	604	67
E	738	414	233	148	246	286	144	137	137	2483	276
F	68	90	134	105	168	124	96	176	176	1137	126
G	143	82	118	49	113	59	53	71	71	759	84
H	36	39	45	57	84	140	188	209	209	1007	112
I	48	42	23	59	45	68	173	84	84	626	70
J	58	78	72	69	28	39	37	30	30	441	49
Grand Total	3673	3528	3405	2941	2969	3319	3112	2972	2972	28891	3210

Data Attched herewith

Re: AVG FUNCTION

tresB — Fri, 06 Jun 2014 10:47:08 GMT

PFA

Re: AVG FUNCTION

Anonymous — Fri, 06 Jun 2014 10:50:24 GMT

hi ,

load all your data in QVW,

use a straight table ,

ADD dimension GRP in Straight table dimension tab,

then go to expression tab add two expression

1. for sum

=sum([Apr-13]+ [May-13]+[Jun-13]+[Jul-13]+[Aug-13]+[Sep-13]+[Oct-13]+[Nov-13]+[Dec-13])

2. for average

=rangeavg([Apr-13], [May-13],[Jun-13],[Jul-13],[Aug-13],[Sep-13],[Oct-13],[Nov-13],[Dec-13])

<<PFA >>

Best

Anant

Re: AVG FUNCTION

Gysbert_Wassenaar — Fri, 06 Jun 2014 10:55:47 GMT

You can't have two total columns, one for total sum and one for average. What you can do is add a calculated dimension. This calculated dimension can't be displayed on the right side of the pivot table, only on the left with the other dimensions. Or you can create a second pivot table (or straight table) with only the GRP dimension and the avg expression. You can then align that second table with the first.

See attached qvw for both options.

Re: AVG FUNCTION

mahesh_agrawal — Fri, 06 Jun 2014 11:32:45 GMT

Awesome use of Dimensionality()

Well done pal. 🙂