Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
nani__87
Contributor
Contributor

Calculating NPS scores in Qlik SEnse

Hi all,

I've this data:

nani__87_0-1612255955088.png

I would like to calculate the NPS score which formula is = ((Promoters - Detractors)/ TOTAL(CountDistinctSurvey))*100

Where I created a new column Promoters = IF (tnps_global_nps_segment_alt = 'Promoters', CountDistinct_surveyid, 0) 

and Detractors = IF (tnps_global_nps_segment_alt = 'Detractors', CountDistinct_surveyid, 0)

 

I am not able to get the TOTAL(CountDistinctSurvey). I am totally new to Qlik Sense.

0 Replies