topic Setting fields in tables in QlikView

Setting fields in tables

Thu, 19 Nov 2009 23:24:35 GMT

Hi,

just a quick and I'm sure relatively simple question. I have a set of data that I am using, one of the columns is our financial period 1 -13, this is stored in a single column, what I would like to be able to do is create a table with the data set with columns 1-13 spread accross the top of the table as seperate columns and the data filled in beneath, how do I do this?

Many Thanks

Ben

AW:Setting fields in tables

Thu, 19 Nov 2009 23:46:48 GMT

Use the CROSSTABLE Statement bevore the load.

Crosstable (period ,data,2) Load * from ex2.csv

It meens

2 Fiels will not turn

period is the name of the Column Heading (1..13)

data is the name of the content

Simple use the "table files"-assitant in the scripteditor

Have Fun! Regards

Dirk

Setting fields in tables

tabletuner — Thu, 19 Nov 2009 23:55:39 GMT

You can also create a pivot table in which you drag the period column to the top of the chart.

Setting fields in tables

johnw — Fri, 20 Nov 2009 01:00:00 GMT

You can also create a straight table in which you select Horizontal on the Presentation tab of the properties.

AW:Setting fields in tables

Fri, 20 Nov 2009 16:37:21 GMT

Hi, I'm sorry I can't fathom how to get these cross tables to work, If my spreadsheet looks like this:

Description	Period	Amount
Desc 1	1	100
Desc 2	3	10
Desc 3	4	20
Desc 4	5	25
Desc 5	7	32
Desc 6	8	54
Desc 7	10	98
Desc 8	11	78
Desc 9	13	45
Desc 10	9	98
Desc 11	2	45
Desc 12	6	12
Desc 13	11	32
Desc 14	13	45
Desc 15	12	78
Desc 16	3	12
Desc 17	5	32
Desc 18	6	45
Desc 19	8	844
Desc 20	7	98
Desc 21	9	54
Desc 22	10	21
Desc 23	11	2
Desc 24	5	5
Desc 25	6	84
Desc 26	8	98
Desc 27	9	88
Desc 28	3	54
Desc 29	4	21
Desc 30	2	954

And I want the periods to be transformed into a layout like this:

Description , Amount, Period 1,2,3,4,5,6,7,8,9,10,11,12,13 - how do I get there?

Thanks

Ben

Setting fields in tables

Fri, 20 Nov 2009 16:39:11 GMT

How do you find horizontal on the properties? When I create a standard table I cannot find any part that says horizontal - am I missing something?

AW:Re: Setting fields in tables

Fri, 20 Nov 2009 18:49:44 GMT

Ok, I misunderstand you.

Read the table it is it.

User a pivot table (chart) with dimension Period and and move the dimension clomn to the column headings with your. The blue arrow show where they are.

-Dirk

Setting fields in tables

johnw — Sat, 21 Nov 2009 01:30:09 GMT


ben.shreeve wrote:How do you find horizontal on the properties? When I create a standard table I cannot find any part that says horizontal - am I missing something?

What do you mean by a "standard table"? What I meant was a "straight table", which is a form of chart. The "horizontal" checkbox is highlighted in black below:

Setting fields in tables

Tue, 24 Nov 2009 18:40:57 GMT

Hey thanks all, managed to get things sorted with the pivot table!