topic Re: gauss curve in histogram in QlikView

gauss curve in histogram

falko_thom — Tue, 11 Jun 2013 11:52:16 GMT

Hello community,

I am quite new experiencing QV.

I have to build a diagram containing a histogram and a bell curve (gauss curve / normal distribution).

For drawing the histogram I am using formula

=count( [DLZ-Tage])

For drawing the bell curve I am using formula

=normdist((ceil(min([DLZ-Tage]))+Floor(Min([DLZ-Tage])))/2,avg({1} total [DLZ-Tage]),stdev({1} total [DLZ-Tage]),0)

[DLZ-Tage] ist the amount of days it takes a single piece of work to be comleted.

My only dimension is

=class([DLZ-Tage], 1)

In my diagram both graphs are shown (see snapshot), but I want the maximum of the bell curve to be drawn at the median (represented by the orange dotted line).

Anybody an idea?

Unfortunately I didn't receive an answer anfter I added the graph. Has anybody an idea that could help me?

Nachricht geändert durch Falko Thom

Re: gauss curve in histogram

Tue, 11 Jun 2013 11:57:47 GMT

I think you failed attaching the document

Re: gauss curve in histogram

Wed, 09 Apr 2014 14:52:34 GMT

Hallo Falko,

try to change your formula appropriate to:

=normdist((ceil(min([DLZ-Tage]))+Floor(Min([DLZ-Tage])))/2, median({1} total [DLZ-Tage]),stdev({1} total [DLZ-Tage]),0)

Regards,

Eddie

Re: gauss curve in histogram

falko_thom — Thu, 10 Apr 2014 09:34:33 GMT

Hi Eddie,

thanks for your answer.

I used the following formula and it worked very well:

=normdist((ceil(min([DLZ-Tage]))+Floor(Min([DLZ-Tage])))/2,Median(total [DLZ-Tage]),stdev(total [DLZ-Tage]),0)

I had to omit the {1} in order to lay the peak of the curve over the median.