4 Replies Latest reply: May 11, 2015 3:58 AM by David Rodriguez RSS

    Problem with key performance indicator calculation

      Hi all!

       

      I have a table in the database with key performance indicators (KPIs), in Qlikview i have a report with pivot table where i sum the values of the KPIs. My problem is that i have to add a new KPIs that is the value between divide others two KPIs.

       

      KPI_data.jpg

      I'm trying with the combination of the functions pick and match, but i can´t do reference to others kpis where my expresion detected this complex KPI.

       

      =pick(match(KPI_ID,'LF')+1,

        Sum(VALUE)

      ,Sum({<KPI_ID={$(='PKO')}>} VALUE) / Sum({<KPI_ID={$(='ASI')}>} VALUE)

      )

       

      I have the kpi calculated into the data base, but really a kpi that is the operation (division) of other two kpis i cannot add the total values, because the total will be wrong, the total value will be the division.

       

      (See attachment for more information.)

       

      Any idea? how can i focus the problem?

       

       

      Thanks for all!!

       

       

      Best regards.