# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for
Did you mean:
Not applicable

## AVG FUNCTION

Hi

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

1 Solution

Accepted Solutions
MVP
4 Replies
MVP

PFA

Specialist

hi ,

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

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.

talk is cheap, supply exceeds demand
Creator

Awesome use of Dimensionality()

Well done pal. 🙂

Community Browser