topic Revenue over time in QlikView https://community.qlik.com/t5/QlikView/Revenue-over-time/m-p/684173#M247978 <HTML><HEAD></HEAD><BODY><P>All,</P><P></P><P>In the attached Qlikview file I have a graph which displays revenue over time.</P><P>The months are based on the Close Date for the opportunity, the bars represent expected revenue.</P><P></P><P>What I need is that the revenue is divided over the months. The full revenue is now plotted on the month of the Close Date but ofcourse if this revenue is earned over 5 months this amount needs to be divided over all the months.</P><P></P><P>The field which says the number of months in the opportunity is below the graph (new_assignmentduration). How can I divide the revenue for each opportunity over the number of months for that opportunity starting at the close date?</P><P></P><P>Thanks for your help and kind regards,</P><P>Paul</P></BODY></HTML> Wed, 24 Sep 2014 15:46:51 GMT pauldamen 2014-09-24T15:46:51Z Revenue over time https://community.qlik.com/t5/QlikView/Revenue-over-time/m-p/684173#M247978 <HTML><HEAD></HEAD><BODY><P>All,</P><P></P><P>In the attached Qlikview file I have a graph which displays revenue over time.</P><P>The months are based on the Close Date for the opportunity, the bars represent expected revenue.</P><P></P><P>What I need is that the revenue is divided over the months. The full revenue is now plotted on the month of the Close Date but ofcourse if this revenue is earned over 5 months this amount needs to be divided over all the months.</P><P></P><P>The field which says the number of months in the opportunity is below the graph (new_assignmentduration). How can I divide the revenue for each opportunity over the number of months for that opportunity starting at the close date?</P><P></P><P>Thanks for your help and kind regards,</P><P>Paul</P></BODY></HTML> Wed, 24 Sep 2014 15:46:51 GMT https://community.qlik.com/t5/QlikView/Revenue-over-time/m-p/684173#M247978 pauldamen 2014-09-24T15:46:51Z Re: Revenue over time https://community.qlik.com/t5/QlikView/Revenue-over-time/m-p/684174#M247979 <HTML><HEAD></HEAD><BODY><P>Have a look at this document on Generating Missing Data</P><P> <A _jive_internal="true" href="https://community.qlik.com/docs/DOC-3786">http://community.qlik.com/docs/DOC-3786</A></P><P><BR /> </P></BODY></HTML> Wed, 24 Sep 2014 15:51:35 GMT https://community.qlik.com/t5/QlikView/Revenue-over-time/m-p/684174#M247979 Colin-Albert 2014-09-24T15:51:35Z