Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

rustagiapurv
New Contributor

Delta function in QlikSense

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.

1 Reply
dwforest
Valued Contributor

Re: Delta function in QlikSense

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]))