0 Replies Latest reply: Jun 22, 2015 10:02 AM by Felipe Muniz RSS

    Expression for average in subset

      Hello everybody,

       

      I'm trying to add a column to a table with the value of one column (Value) divided by the average of the values from the same Name and Label as you can see in the picture. In another words, I would like to add a column with x divided by the average of y, where "y" are the values from the same name and label of the entry.

       

      the output I want is:

       

      2.555,45/2.311  = 1.1

      1.870,83/ 2.311 = 0.796

      (...)

       

      The problem is to find the average of this subset, instead of the average of all values of the table. I'm sure it's really simple, but I started with Qlikview this week, so I'm having some simple problems...

       

      Thanks a lot!