topic Bell Chart curve in QlikView

Bell Chart curve

Wed, 10 Aug 2016 07:56:11 GMT

Hello all,

I plotted a bell curve with Dimension as Class(Performance,0.1) and Expression as Count(Performance) and am getting bell curve like below image.

But median and Standard Deviation needs to be taken into account, Please help me in doing this.

Thanks in advance.

Re: Bell Chart curve

adamdavi3s — Thu, 11 Aug 2016 13:49:59 GMT

have you explored the normdist function?

Re: Bell Chart curve

adamdavi3s — Thu, 11 Aug 2016 13:50:45 GMT

A good example here:

https://community.qlik.com/thread/139251

Re: Bell Chart curve

Clever_Anjos — Thu, 11 Aug 2016 14:00:26 GMT

Re: Bell curve

Re: Bell Chart curve

Fri, 12 Aug 2016 04:35:26 GMT

Hello Clever,

Thank you for valuable reply.

Can you please copy and paste the code? coz we are using Personnel edition ,not able to open example:(

Thanks In Advance.

Re: Bell Chart curve

Fri, 12 Aug 2016 08:18:28 GMT

Hello Adam,

Thank you for your valuable reply.

Now i changed dimension as

normdist( CLASS(Performance, 0.1) ,avg({1} total CLASS(Performance, 0.1)),stdev({1} total CLASS(Performance, 0.1)),0 )

Now the chart is looks like below

But the requirement is the bell curve should shows which group of sellers are the mean and where other sellers should be at in terms of performance to goal.

Please suggest.

Thanks in advance.