Delta function in QlikSense

Anonymous — Tue, 04 Sep 2018 06:07:44 GMT

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.

Re: Delta function in QlikSense

dwforest — Tue, 04 Sep 2018 20:57:54 GMT

Denominator needs to be:

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

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