Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Distribution a value over a certain amount of time using a normal curve?

Hello,

I am new to qlikview and I am getting my first taste of graphing. I have a  large quantity of line items and 4 main columns. A PROJECT TITLE, a TOTAL DOLLAR VALUE and a START DATE and END DATE. What I would like to do is spread that TOTAL DOLLAR VALUE using a normal bell curve meaning most of the dollar value would be spent at the peak of the bell curve and the bell curve tails would start and end at my START DATE and END Date.

Does anybody know if this can be done?

Thank you for your help!

2 Replies
Not applicable

Re: Distribution a value over a certain amount of time using a normal curve?

I would also like to add that I would want it to be a single bell curve per line item of data and still have the possibility of stack all those independent bell curves.

Thank you!

MVP
MVP

Re: Distribution a value over a certain amount of time using a normal curve?

I think this can be achieved (depart from the fact that the bell curve's tail does not have a start and end point).

You can use the normdist() function for that:

TOTAL_VALUE * NORMDIST( DATE , MEAN_DATE, 6_SIGMA_VALUE / 6, 0)

where you need to calculate your MEAN_DATE from Start and end date and 6_SIGMA could equal half of End-Start date interval.

Community Browser