Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

pivot table design

in the attached qvw file there is sheet named "not working" . How can i get meanA for each month.

month name                     meanA

dec 2012                             98

dec 2012                            100

nov 2012                             88

2 Replies
Not applicable

Re: pivot table design

Into the expression you set

 

avg

(MeanB)      not  avg(meanB) .

Bye

Marco

christian77
Valued Contributor

Re: pivot table design

AGGR(AVG(meanA),Month,Year)