Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
praveensp
New Contributor

Generating a planned value based on actual value for a period of time

Hi,

 

I need some help in QlikView.

I have a PMO dashboard to create. I need to generate a series of values based on an actual value for a period of time.

For example, I have a project and i have a budget for that project. Also i have time duration for that project say 12 months.

Now I need to distribute this budget for 12 months. Just the way we use NORM.S.DIST in excel.

I am attaching an excel with calculation and steps to follow.

Let me know if this is possible. If YES, then how?

Labels (2)
1 Reply
MVP & Luminary
MVP & Luminary

Re: Generating a planned value based on actual value for a period of time

Qlikview does have a normdist function. Perhaps this discussion can help you: https://community.qlik.com/t5/QlikView-Layout-Visualizations/Plotting-Normal-Dirstribution-bell-curv...

talk is cheap, supply exceeds demand