4 Replies Latest reply: Mar 8, 2018 6:21 AM by Tim Müller RSS

    Use a defined KPI in another KPI measure in master items?

    Tim Müller

      Hi Folks,

       

      I have defined two measures in master items. KPI A and KPI B.

       

      KPI A is defined as following:

      A =

      long-term liabilities

      +

      short-term liabilities.

       

      KPI B is defined as following:

      B =

      stocks

      +

      requirements.

       

       

       

      I want to create KPI C:

      C =

      A

      -

      B.

       

      The situation is, Qlik Sense gives an error message, when I edit formula C and put in A - B.

       

      The only way so far is confusing and following:

      C =

      long-term liabilities

      +

      short-term liabilities

      -

      stocks

      -

      requirements.

       

      I heard about the possibility of storing formulas in variables and using them in other formulas (in this case "C"). I'm at a loss, because the previous method is very confusing to create KPIs that use other KPIs.


      Can someone give me a key word, which allows me to google?

       

      Thanks a lot

      Tim