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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Pivot table with dimension in rows and colums

Hello,

I need a pivot table with dimensions in rows and columns, something as this:

pivot_table.PNG

¿Is this possible?

Thanks

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

You can't have two dimensions as rows in one column. You can have two dimensions arranged horizontally. Drag the header of the dimension to the right to above the expressions. When you see a think blue line let go and the dimension will be pivotted to horizontal layout. Repeat the for each dimension that you want shown as columns.


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

You can't have two dimensions as rows in one column. You can have two dimensions arranged horizontally. Drag the header of the dimension to the right to above the expressions. When you see a think blue line let go and the dimension will be pivotted to horizontal layout. Repeat the for each dimension that you want shown as columns.


talk is cheap, supply exceeds demand