2 Replies Latest reply: Jul 27, 2017 3:43 PM by Saima SM RSS

    Filter based Caluculation-Qlik Sense

    Saima SM

       

      I have a table having “Team Member”  , “Team Member Profession”  ,” No.Booked” , “No.Available” fields

       

      I have filters “Team Member filter”, “Profession filter”

       

      When I select one Team Member from filter , I can get “UTILIZATION” kpi figure with following formula

       

      Sum([No.Booked])/Sum([No.Available])

       

      And when I filter Team Member, its associated “Professions remain active in “Profession Filter” while all other gets disable(Greyed). When I select that Profession from filter pan,  I  get another KPI figure for profession utilization with following formula.

       

      SUM({<[Team Member]=>}[No.Booked]) / SUM({<[Team Member]=>}[No.Available])

       

       

       

      But my requirement is that when I select Team Member it should give me the Profession utilization figure without explicitly selecting filtered out “Profession” based on Team Member Selected. How can I change my profession utilization formula to achieve this.

       

      Please Help. Thanks