8 Replies Latest reply: Jun 11, 2014 7:04 AM by Eduardo Sommer RSS

    Creating a KPI

    Matthias Karl

      Hi

       

      I'm pretty new to Qlikview and struggle with creating a KPI.

       

      I am trying to get a value in relation of another. I want to create an average personnel cost by dividing the total personnel cost (AC3 = 610) through the total employee (AccountCode = 96000). The formula looks like this:

       

      Sum(If(AC3='610',Amount,0))/SUM(If(AccountCode='96000',Amount,0))

       

      When I use the first part, I get proper values, when I only use the second part, I also get the proper values. But both parts together simply show nothing to display.

       

      How can I make that division?