topic Re: NPS calculation in QlikView

NPS calculation

Tue, 30 Jun 2015 17:22:35 GMT

Hi all, first of all sorry if this is a very noob question but I'm with it two hours and I'm desperate.

I have a variable called NPS. I'm drawing a graph with the dimension Months and in the expression I want to add the NPS formula

(Count(NPS>8)-Count(NPS<7)/Count(NPS>=0))*100

The problem is that all the count provides me the same value that is the number of NPS values.

For example in January:

Count(NPS>8) = 1133

Count(NPS>0) = 1133

Count(NPS<7) = 1133

In NPS properties I have changed in the Number TAB the configuration to Integer.

Thanks in advance for your support.

Regards

Re: NPS calculation

marcus_sommer — Tue, 30 Jun 2015 18:20:15 GMT

Maybe so:

(count({< NPS = {">8"}>} NPS) - count({< NPS = {"<8"}>} NPS)) / count({< NPS = {">=0"}>} NPS) * 100

- Marcus

Re: NPS calculation

hic — Tue, 30 Jun 2015 19:20:49 GMT

NPS>8 will evaluate to -1 (true) or 0 (false). Both these values will be counted by Count(). If you want to use a condition inside your Count() you need to use

Count( If(NPS>8,NPS,Null()) )

Count( {$<NPS={">8"}>} NPS )

Long story short: Marcus' expression will work.

HIC

Re: NPS calculation

Tue, 30 Jun 2015 19:44:56 GMT

Thanks very much for your answer for both the right answer and take your time for the explanation. I really appreciate your support.

Thanks and I hope to return the favor some day

Regards

Javi

Re: NPS calculation

MarcoWedel — Tue, 30 Jun 2015 20:10:35 GMT

-(Sum(NPS>8)+Sum(NPS<7)/Sum(NPS>=0))*100

might also work.

hope this helps

regards

Marco