topic Transpose column in QlikView

Transpose column

Tue, 09 Aug 2011 12:55:00 GMT

Hi!

I am wondering if the following can be done;

I have tried using crosstables, but can't get it to work. Can someone please help me? Or at least tell me if it can be done?

Thanks and regards,

Stefan

Re: Transpose column

Tue, 09 Aug 2011 13:11:22 GMT

Use a chart - either a Pivot or Straight table. I created one in your sample.

Re: Transpose column

its_anandrjs — Tue, 09 Aug 2011 13:11:34 GMT

Hi,

See the attached file by this you can change the view of your columns in Pivot table and represent the data like this. Please see attachment is this your solution see the solutions Sheet.

Hope this helps you.

Regards,

Anand

Re: Transpose column

Tue, 09 Aug 2011 13:26:20 GMT

Thank you for the help.

I don't really follow. I may have given more information than I can use in the solution. I only have the table given to the left. Am I mistaken, or have you in your solution used information from the table to the right?

I am providing a new example, just containing the information I can use.

Re: Transpose column

Tue, 09 Aug 2011 13:35:21 GMT

You need to create a pivot table - dimensions are 'startweek' & 'importweek', and the expression is =Forecast. You can expand all dimensions on the pivot table, then drag & drop the 'importweek' column (initially displayed in rows) to a column header. Let me know if the attached file solves your problem.

Re: Transpose column

Tue, 09 Aug 2011 13:41:18 GMT

That worked as a charm! Thank you!

Re: Transpose column

Tue, 09 Aug 2011 14:05:20 GMT

Is it possible to achieve the same with just a straight table? I find the look of the pivot table... confusing

Edit: I found the "Always fully expanded" checkbox in presentation tab. That made it a little less confusing.

Re: Transpose column

Tue, 09 Aug 2011 14:15:53 GMT

You can get the same data from a straight table, but the only way to get a dimension as column headers is by pivoting. A straight table version will look like the image attached. (Sorry, tried to paste, but the insert picture fuction isn't working)

Transpose column

Tue, 09 Aug 2011 14:19:10 GMT

Ok, thank you anyway!