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:

      qvtable.jpg

       

      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:

       

      qvtableedit.jpg

       

      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