Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
See attached qvw
Thank you very much Gysbert. Works perfectly
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
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.