Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can I transpose the results from a Table Object?

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
OriginalPrincipalBalanceCurrencyLocalClosingDateContractualMaturityDate
                      (60,000,000.00)USD1/20/20066/1/2013
Desired View:
OriginalPrincipalBalance (60,000,000.00)
CurrencyLocalUSD
ClosingDate1/20/2006
ContractualMaturityDate6/1/2013
4 Replies
v_iyyappan
Specialist
Specialist

Hi,

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

Regards,

Iyyappan

jonathandienst
Partner - Champion III
Partner - Champion III

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
Not applicable
Author

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

Not applicable
Author

Thanks for the help - the straight table worked!