2 Replies Latest reply: Feb 11, 2013 9:52 AM by SAMUEL MOORE RSS

    Table Values Average - Aggregation

      Hi all,


      I have only very recently began learning QlikView and need some help with the following table:



      As it stands the responses are showing one row per response. So each column shows each individual score - what I need is an average - so that the table will look like this:




      Is this possible with an expression/aggregation? Will the null values affect the average?


      Please bear in mind that I'm pretty much a beginner, so try to keep the explanations simple!


      Any help is much appreciated.


      Message was edited by: smoore009 14:41