Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Gauss-Bell

Hey!

I would like to plot a Gauss-Bell. My X-Axe is 0; 0,001; 0,002 ... 0,999; 1. The Gauss-Bell should have the variable Mean_Zyl und StdDev_Zyl als mean und standardeviation.

In Excel I use: NORMDIST. The same function in Qlikview doesnt plot a bell, but a cumulative distribution function. I don't want it to be cumulative...

Can you please help me??

Eduardo

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Gauss-Bell

There is in fact a fourth argument you can use with the normdist() function (it's not in the HELP, but in the editor tooltip), where you can switch between cumulative and non cumulative mode, so

normdist( value, mean, stdev, 0 )

should work.

2 Replies
MVP
MVP

Re: Gauss-Bell

There is in fact a fourth argument you can use with the normdist() function (it's not in the HELP, but in the editor tooltip), where you can switch between cumulative and non cumulative mode, so

normdist( value, mean, stdev, 0 )

should work.

Not applicable

Re: Gauss-Bell

That's exactly what I needed!!!!! Thank you!

Eduardo

Community Browser