0 Replies Latest reply: Sep 24, 2017 9:43 PM by Sukla Alkmim RSS

    Calculate using Master Itens

    Sukla Alkmim

      Hi,

       

      I'm new to Qlik Sense and I'm creating some charts.

      I've already created two Master Itens. Now I want to calculate them by a simple SUM(Master1 - Master2).

       

      Can I use those Master Itens to create a new one?

       

      My Master Itens are:

      Opened:

      Count([Opening.Month])

      Closed:

      SUM(IF([Opening.Month] = [Closed.Month], 1, 0))


      The result would be:

      SUM(Opened - Closed)

       

      I've searched on community but don't found it.

       

      Regards.