topic Re: Chart not showing numbers that are calculated in QlikView

Chart not showing numbers that are calculated

Fri, 01 May 2015 12:28:36 GMT

Hi,

I'm relatively new to QlikView so this might be something really simple ...

I'm trying to chart Net Promoter Scores by month.

Net Promoter Score = % Promoters - % Detractors

I've set up variables to calculate the % Promoters and % Detractors

I've checked these against the original spreadsheet and these are calculating correctly by month.

However, when I use these variables as Expressions a monthly chart, I get completely different numbers displaying on the chart.

Any ideas?

Thanks,

Tim.

Re: Chart not showing numbers that are calculated

petter — Fri, 01 May 2015 16:51:42 GMT

I think you accidentally checked the option for relative for all of your expressions. That leaves you with wrong calculations - rather go to the Numbers tab an select all your expressions there and select "Fixed to 1 decimals" and check the check box "Show in Percent (%)". See below:

Re: Chart not showing numbers that are calculated

Fri, 01 May 2015 22:13:54 GMT

*Facepalm* Doh!

Perfect!

Thanks, Petter.

And thanks for responding so quickly.

Much appreciated,

Tim.

Re: Chart not showing numbers that are calculated

petter — Fri, 01 May 2015 22:16:33 GMT

It was a correct answer .... wasn't it?

Re: Chart not showing numbers that are calculated

Fri, 01 May 2015 22:23:18 GMT

Thanks Petter,

Yes, it was.

I'm now desperately searching the screen for a way to mark the question as resolved!

Tim.