Forecast Data help please!

[#1]

Hi all

I'm a newbie that could really do with some assistance.  The data I have available to me is as follows:

Project	Anticipated Launch date	Expected 3 Year Sales Value	PeriodValue
P1	01/06/2014	50000.00	1388.888889
P2	01/07/2014	50000.00	1388.888889
P3	01/07/2014	50000.00	1388.888889
P4	01/08/2014	40000	1111.111111
P5	01/10/2014	5000	138.8888889

I want to bar chart in qlikview that plots the period value across 36 months from the 'Anticipated launch date'

eg  every month from 01/06/2014 plot £1388. every month from 01/07/2014 plot £1388 and so on.

Any help will be greatly appreciated.

[Gysbert_Wassenaar · Accepted solution]

See attached qvw

[#3]

Thank you very much Gysbert.  Works perfectly

[#4]

Hi Gysbert

Thanks again for the example you very kindly gave me this morning.  Would it be possible for you to tell me how to left justify the monthyear column within the load ?

Thank you

[Gysbert_Wassenaar]

Left justify sounds like a layout change, not data processing. That's something that cannot be done in the load script. You'll need to set that on the Presentation tab of the table box or chart object.