Normal distribution in Qlikview

[#1]

Hi,

How to plot normal distribution of sales in Qlikview, I want to show distribution of sales by employees, can anyone please help.

Regards,

Navdeep

[amit_saini]

Hi,

You can call Employees as Dimension and =sum(Sales) as expression in bar chart or in straight table.

Thanks,

AS

[avinashelite]

Hi,

If you have the Employee as the column in the DB then please follow as told by Amit , if your facing any issue please post your app and sample data

[#4]

Hi,

Please find attached the app and sample output image, I want sales in normal distribution with different levels of standard deviation.

In attached image Henric has used sales in dimension but I want Employee Name and when I do continuous in axes, it says no numeric value. Recipe for a Histogram

Regards,

Navdeep

[avinashelite]

please go through this document , hope this is what your looking for ?

Creating a Candle light Chart or Box Plot Chart with custom Pop up of Plot values

[#6]

Thanks Avinash, But my requirement is little different, I don't want spread of each employee. I am looking for a chart where each employee performance is visible and it's difference from mean with difference value, like bell curve.

[Anonymous]

Hi,

I want to Draw a histogram / Bell curve.

i need to draw the median line.

as target line (red Line) in Histogram2.png

Regards,

PW

[Frank_Hartmann]

attached sample might be helpful

[#9]

Did you find solution to draw Target Red Line.