topic Re: z-score in table object in QlikView

z-score in table object

Wed, 30 Nov 2011 20:17:33 GMT

Dear all,

I want to create a table - see image - which show the z-scores for each company (instead of the normal scoring which is currently in the table). Does somebody know the expression to get this done? I can't find it.

ps. z-scores describe the distance of the company score to the mean, expressed in standarddeviation.

Re: z-score in table object

johnw — Wed, 30 Nov 2011 21:08:44 GMT

This would be easier with an example file to play with, but let's see. I'm guessing that each company has a single score? So the mean (since you want it in the chart) is probably:

avg(total Score)

And the standard deviation is probably:

stdev(total Score)

And so your z-score would probably be:

(Score - avg(total Score))/stdev(total Score)

Re: z-score in table object

Wed, 30 Nov 2011 22:07:28 GMT

Fantastic John, It works. Thanks for quick response.

Re: z-score in table object

jmmayoral3 — Mon, 05 Sep 2022 11:25:26 GMT

Very good answer and very simple.

I have espent a lot of time searching a function which does a zcore in the documentation ofSense.