12 Replies Latest reply: Jul 18, 2017 4:53 AM by Joanna Seldon RSS

    Add two types of percentage calculation together in one measure on a bar chart

    Joanna Seldon

      Hi

       

      Using Qlik Sense

       

      I am trying to Add two types of percentage calculation together in one measure on a bar chart

       

      The dimension is calendar year

       

      I currently have two percentage measures on the bar chart

       

      the calculations look like

       

      e.g

       

      count({$<SectorID={"1"}, OrderCompleted = {"Yes"}>}SectorID) / count({$<SectorID={"1"}>}SectorID)

       

      but I wish to add / combine this second calculation percentage as one measure on the bar chart

       

      sum({$<SectorID={"20"}>}FinalSaleValue) / sum({$<SectorID={"20"}>}OverallSaleValue)

       

       

      I have tried with no joy encapsulating the vales

       

      (count({$<SectorID={"1"}, OrderCompleted = {"Yes"}>}SectorID) / count({$<SectorID={"1"}>}SectorID)) +

       

      (sum({$<SectorID={"20"}>}FinalSaleValue) / sum({$<SectorID={"20"}>}OverallSaleValue))

       

       

      please help