Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Setting fields in tables

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

1 Solution

Accepted Solutions
tabletuner
Creator III
Creator III

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

View solution in original post

8 Replies
Not applicable
Author

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

tabletuner
Creator III
Creator III

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

johnw
Champion III
Champion III

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

Not applicable
Author

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

DescriptionPeriodAmount
Desc 11100
Desc 2310
Desc 3420
Desc 4525
Desc 5732
Desc 6854
Desc 71098
Desc 81178
Desc 91345
Desc 10998
Desc 11245
Desc 12612
Desc 131132
Desc 141345
Desc 151278
Desc 16312
Desc 17532
Desc 18645
Desc 198844
Desc 20798
Desc 21954
Desc 221021
Desc 23112
Desc 2455
Desc 25684
Desc 26898
Desc 27988
Desc 28354
Desc 29421
Desc 302954


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

Not applicable
Author

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?

Not applicable
Author

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

johnw
Champion III
Champion III


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:

Not applicable
Author

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