How can I transpose the results from a Table Objec... - Qlik Community

Report Inappropriate Content · ‎2013-09-27

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

v_iyyappan · ‎2013-09-27

Hi,

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

Regards,

Iyyappan

jonathandienst · ‎2013-09-27

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

Anonymous · ‎2013-09-27

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

Report Inappropriate Content · ‎2013-09-27

Thanks for the help - the straight table worked!

How can I transpose the results from a Table Object?