topic Re: How can I transpose the results from a Table Object? in QlikView

How can I transpose the results from a Table Object?

Fri, 27 Sep 2013 13:19:42 GMT

I'd like to display a handful of fields in a summary page in a table view. I'd like the field names to be down the first column with the field values in the second column, but I have only been able to get it in row-form.

ClikView Table
OriginalPrincipalBalance	CurrencyLocal	ClosingDate	ContractualMaturityDate
(60,000,000.00)	USD	1/20/2006	6/1/2013

Desired View:
OriginalPrincipalBalance	(60,000,000.00)
CurrencyLocal	USD
ClosingDate	1/20/2006
ContractualMaturityDate	6/1/2013

Re: How can I transpose the results from a Table Object?

v_iyyappan — Fri, 27 Sep 2013 13:24:26 GMT

Hi,

In Qlikview using Pivot table you can drag and drop the filed whatever you want. Please try that.

Regards,

Iyyappan

Re: How can I transpose the results from a Table Object?

jonathandienst — Fri, 27 Sep 2013 13:27:33 GMT

Or you can use a straight table and select the "Horiziontal" option on the Properties | Presentation.

Jonathan

PS - turn off the totals on the expressions to suppress the column.

Re: How can I transpose the results from a Table Object?

Anonymous — Fri, 27 Sep 2013 13:27:34 GMT

It is a staright table with option "Horizontal" - see Presentation tab in chart properties

Re: How can I transpose the results from a Table Object?

Fri, 27 Sep 2013 17:27:49 GMT

Thanks for the help - the straight table worked!