topic Getting columns of data from Excel in QlikView

Getting columns of data from Excel

Wed, 15 Jul 2009 17:34:02 GMT

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.

Getting columns of data from Excel

amit_shetty78 — Wed, 15 Jul 2009 18:31:02 GMT

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.

Getting columns of data from Excel

Wed, 15 Jul 2009 19:14:56 GMT

Many thanks. It worked!