Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I'm very new to QV (downloaded Personal Edition yesterday!). I want to experiment with a Financial Control scenario. I have an Excel spreadsheet with 400 rows of various of income and expense headings, and 6 colums representing January to June.The relevant code in my Script looks like this:
LOAD [Nominal Code],
[Account Description],
Jan,
Feb,
Mar,
Apr,
May,
Jun,
[Jun YTD],
F11,
F12,
F13,
F14
FROM
(biff, embedded labels, table is [TB 2009_01$]);
How do I create a simple line graph to plot say, Income month by month? When I design the chart, the Dimensions allowable are Jan, Feb, Mar, Apr, May, Jun, etc,. I can only seem to get 1 month's data in my chart at any one time. Also, what Expression do I need to use?
Thanks to anyone who can give me some pointers to get started.
To start off you may need to load the data into QV in using crosstable.
CROSSTABLE(Month, Income, 2)
LOAD [Nominal Code],[Account Description],
[Jan], [Feb], [Mar], [Apr], May], [Jun]
FROM(biff, embedded labels, table is [TB 2009_01$]);
This will give you a table with the following structure when loaded into QV:
Nominal Code, Account Description, Month, Income.
Using this you would be able to create the chart to your liking.
Rgds,
Amit.
To start off you may need to load the data into QV in using crosstable.
CROSSTABLE(Month, Income, 2)
LOAD [Nominal Code],[Account Description],
[Jan], [Feb], [Mar], [Apr], May], [Jun]
FROM(biff, embedded labels, table is [TB 2009_01$]);
This will give you a table with the following structure when loaded into QV:
Nominal Code, Account Description, Month, Income.
Using this you would be able to create the chart to your liking.
Rgds,
Amit.
Many thanks. It worked!