Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Getting columns of data from Excel

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.

Tags (3)
1 Solution

Accepted Solutions
amit_shetty78
Contributor II

Getting columns of data from Excel

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.

2 Replies
amit_shetty78
Contributor II

Getting columns of data from Excel

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.

Not applicable

Getting columns of data from Excel

Many thanks. It worked!