topic Re: Reverse Pivot Table Layout? in QlikView

Reverse Pivot Table Layout?

Tue, 03 Feb 2015 15:16:38 GMT

I think my Excel background is really showing.

My qlikview pivot table (from an ODBC data source) has the columns where I want the rows and vice versa.

How can I reverse them?

See attached.

Thanks!

Re: Reverse Pivot Table Layout?

giakoum — Tue, 03 Feb 2015 15:20:24 GMT

Crosstable

A cross table is a common type of table featuring a matrix of values between two or more orthogonal lists of header data, of which one is used as column headers. A typical example could be to have one column per month. To transform a cross table into a straight table, use a crosstable prefix. The result is that the column headers (e.g. month names) will be stored in one field - the attribute field - and the column data (month numbers) will be stored in a second field: the data field.

The syntax is:

crosstable (attribute field name, data field name [ , n ] ) ( loadstatement | selectstatement )

where:

attribute field name is the field to contain the attribute values.

data field name is the field to contain the data values.

n is the number of qualifier fields preceding the table to be transformed to generic form. Default is 1.

Examples:

Crosstable (Month, Sales) Load * from ex1.csv;

Crosstable (Month,Sales,2) Load * from ex2.csv;

Crosstable (A,B) Select * from table3;

Crosstable Wizard

The crosstable wizard is dialog driven method of creating the crosstable statement. This dialog is opened by clicking the Crosstable button in the Options page of the File Wizard

Re: Reverse Pivot Table Layout?

mazacini — Tue, 03 Feb 2015 17:57:31 GMT

Did you try to drag the dimensions from columns to rows and vice versa?

Joe

Re: Reverse Pivot Table Layout?

reshmakala — Tue, 03 Feb 2015 18:17:41 GMT

Press and hold on a column header and drag to your desired position. A blue arrow appears to show you where it can be inserted.

Re: Reverse Pivot Table Layout?

Tue, 03 Feb 2015 21:55:24 GMT

Yes, and it didn't seem to work. I've done that successfully before...

Re: Reverse Pivot Table Layout?

mazacini — Tue, 03 Feb 2015 22:00:12 GMT

Have you deleted any dimensions which are still referenced in the Used Dimensions section?

I sometimes find these block the drag and drop feature

Re: Reverse Pivot Table Layout?

giakoum — Tue, 03 Feb 2015 22:49:12 GMT

is allow pivoting checked? Presentation tab

Re: Reverse Pivot Table Layout?

Wed, 04 Feb 2015 14:27:30 GMT

It's not an option...this is a straight table.

Re: Reverse Pivot Table Layout?

Wed, 04 Feb 2015 14:29:28 GMT

Do you mean ones I'm not using anymore or that no longer exist?

Re: Reverse Pivot Table Layout?

Wed, 04 Feb 2015 14:30:05 GMT

Only letting me drag columns - not allowing me to go up - I suspect it's because this is a straight table..I've done that before with pivot tables...

Re: Reverse Pivot Table Layout?

reshmakala — Wed, 04 Feb 2015 14:31:43 GMT

The cross table functionality is possible for pivot tables but not straight tables.

Re: Reverse Pivot Table Layout?

Wed, 04 Feb 2015 14:49:35 GMT

Thanks - I've switched it to a pivot and am still having trouble, but I'll keep trying...

Re: Reverse Pivot Table Layout?

reshmakala — Wed, 04 Feb 2015 14:53:01 GMT

Sure. Let me know if you need help and attach a sample app if you need further help. Thanks!

Re: Reverse Pivot Table Layout?

Wed, 04 Feb 2015 15:05:25 GMT

You are wonderful! Thank you!

Re: Reverse Pivot Table Layout?

mazacini — Wed, 04 Feb 2015 18:39:30 GMT

Apologies - this is probably the first thing I should have asked!

Re: Reverse Pivot Table Layout?

Thu, 05 Feb 2015 21:40:23 GMT

No problem - it actually WAS a pivot table when I took the screenshot!