topic Re: Calculating a Net Promoter Score in QlikView

Calculating a Net Promoter Score

Thu, 22 Jan 2015 15:32:40 GMT

Hello,

I am summarizing a Net Promoter Score Survey in QlickView. I have one column that asks the question would you ever recommend us? Answers can range from 1. Certain, 2, Very Likely, 3. Somewhat Likely, 4, Somewhat Unlikely, 5. Very Likely 6. Absolutely Not. I can create a nice graph that shows the distribution of the responses, but to obtain the NPS Score I have to do the follow Count the number of responses (1. Certain + 2. Very Likely) - (5. Very Unlikely + 6. Absolutely Not).

Can any one explain how I would accomplish this?

Thanks

Re: Calculating a Net Promoter Score

morganaaron — Thu, 22 Jan 2015 15:39:19 GMT

Count({<[Answer Field]={'1. Certain', '2. Very Likely'}>}[Answer Field])

Count({<[Answer Field]={'5. Very Unlikely', '6. Absolutely Not'}>}[Answer Field])

Re: Calculating a Net Promoter Score

Thu, 22 Jan 2015 16:17:42 GMT

Hi Arron,

Thank you for your help. this is close but didn't get me exactly what I wanted and maybe I didn't explain myself correctly.

I need to sum the count of (Certain + very likely)= Positive, then I need to sum the count of (Very Unlikely + Absolutely Not) = negative and then the NPS = Positive - Negative

This is what I get with the answer you gave me

Re: Calculating a Net Promoter Score

morganaaron — Thu, 22 Jan 2015 16:21:18 GMT

Hi Sue,

My solution would work to calculate the overall NPS in a text box for example (if you write it out in a text box, it will give you the number of positive - number of negative).

What are you looking for under positive and negative in the table, a count of the relevant performance scores, or do you want the NPS to be repeated across all of the scores?

Re: Calculating a Net Promoter Score

Thu, 22 Jan 2015 20:09:04 GMT

Hi Arron,

I almost have it, although I haven't made it pretty yet . How can I turn these numbers into a % of the total count?

Also I still don't seem to be able to get the NPS score. I have:

='NPS' & ' ' & Count ({<[25PerformanceRecommend]={'Certain', 'Very Likely'}>}[25PerformanceRecommend]) - Count ({<[25PerformanceRecommend]={'Very Unlikely', 'Absolutely Not'}>}[25PerformanceRecommend])

Thanks Sue

Re: Calculating a Net Promoter Score

Fri, 23 Jan 2015 19:07:21 GMT

Thank you Arron. I have it working