Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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]))