8 Replies Latest reply: Jun 19, 2012 9:37 AM by Raj Vadde RSS

    question about average

    Raj Vadde

      Hi Qlikgurus,

                         i need to work out an expression but it's showing me null

       

      my data is like this

       

      col1-  24%  

      col2-  17%

      col3-   19%

      col4-   20%

       

      AVG -   20%

       

      this is how it looks in the straight table and now i want that avg vaule i.e 20 in my case as 3rd column like this

       

      col1-  24%      20

      col2-  17%       20

      col3-   19%       20

      col4-   20%       20

       

      Total -   20%      20

       

       

       

      for vaules 24, 17, 19 20 i'm using some set anaysis expression

       

      how do write expression for getting that avg 20 vaules  ..can somebody help me

       

       

      Thanks

      Have a great day