topic Calculating NPS scores in Qlik SEnse in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Calculating-NPS-scores-in-Qlik-SEnse/m-p/1779220#M5753 <P>Hi all,</P><P>I've this data:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="nani__87_0-1612255955088.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/48178i300108CB5E3DE64A/image-size/medium?v=v2&amp;px=400" role="button" title="nani__87_0-1612255955088.png" alt="nani__87_0-1612255955088.png" /></span></P><P>I would like to calculate the NPS score which formula is = ((Promoters - Detractors)/ TOTAL(CountDistinctSurvey))*100</P><P>Where I created a new column Promoters = IF (tnps_global_nps_segment_alt = 'Promoters', CountDistinct_surveyid, 0)&nbsp;</P><P>and Detractors = IF (tnps_global_nps_segment_alt = 'Detractors', CountDistinct_surveyid, 0)</P><P>&nbsp;</P><P>I am not able to get the TOTAL(CountDistinctSurvey). I am totally new to Qlik Sense.</P> Tue, 02 Feb 2021 08:55:23 GMT nani__87 2021-02-02T08:55:23Z Calculating NPS scores in Qlik SEnse https://community.qlik.com/t5/Connectivity-Data-Prep/Calculating-NPS-scores-in-Qlik-SEnse/m-p/1779220#M5753 <P>Hi all,</P><P>I've this data:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="nani__87_0-1612255955088.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/48178i300108CB5E3DE64A/image-size/medium?v=v2&amp;px=400" role="button" title="nani__87_0-1612255955088.png" alt="nani__87_0-1612255955088.png" /></span></P><P>I would like to calculate the NPS score which formula is = ((Promoters - Detractors)/ TOTAL(CountDistinctSurvey))*100</P><P>Where I created a new column Promoters = IF (tnps_global_nps_segment_alt = 'Promoters', CountDistinct_surveyid, 0)&nbsp;</P><P>and Detractors = IF (tnps_global_nps_segment_alt = 'Detractors', CountDistinct_surveyid, 0)</P><P>&nbsp;</P><P>I am not able to get the TOTAL(CountDistinctSurvey). I am totally new to Qlik Sense.</P> Tue, 02 Feb 2021 08:55:23 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Calculating-NPS-scores-in-Qlik-SEnse/m-p/1779220#M5753 nani__87 2021-02-02T08:55:23Z