0 Replies Latest reply: Oct 3, 2016 10:56 AM by carlos Perez RSS

    Average Function

    carlos Perez

      Hi, I am new with Qlik Sense. I am trying to use the average function and is not working. Here is what I want to do:

       

      I have a table with KPI information in one column and the data per month in the other columns, example:

       

      KPIJan-2016Feb-2016Mar-2016
      1. Number of Claims245
      2. % of past due Claims vs. Open Claims10%8%12%

       

       

      So, technically, the KPI 1 should be 3.66 and the KPI 2 should be 10%. Is there anyway to do it in the same Gauge?