1 Reply Latest reply: Sep 4, 2018 4:57 PM by David Forest RSS

    Delta function in QlikSense

    APURV RUSTAGI

      Hi, I'm stuck in a Delta% function in QlikSense.
      Delta is calculated as a difference between 2 quantities, which was easy to derive.

      Delta% has the following formula from Excel i.e (Delta/Sum of all +ve Delta) but I'm not able to generate any values.

       

      Below is the expression I'm trying to implement -

      (Sum({<[KPI Name]={'#Buy Lead Conversions (PH)'},flag={'BMCTotalITM'},Year={'2017'}>}[Targets])-

      Sum({<[KPI Name]={'#Buy Lead Conversions (PH)'},flag={'BMCTotalITM'},Year={'2018'}>}[KPI Value]))

      /

      (Sum({<[KPI Name]={'#Buy Lead Conversions (PH)'},flag={'BMCTotalITM'},Year={'2017'}>}Targets)-

      Sum({<[KPI Name]={'#Buy Lead Conversions (PH)'},flag={'BMCTotalITM'},Year={'2018'}>}[KPI Value]))

       

      Pls do help.