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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Krish
Contributor III
Contributor III

Multiple Dimensions in Qliksense pivot

Hi Team,

                  I am creating a QlikSense Pivot chart and it has multiple dimensions and measures.

When I change the orientation of one the dimensions from rows to columns and add two measures, the dimension is not showing as intended.

My Expectation is :

      Science Maths
Name ID Subject Term1 Term2
AB 1   85 95
BC 2   90 95
CD 3   100 100

 

But I am getting the below:

      Term1 Term2
Name ID Subject Science  Maths
AB 1   85 95
BC 2   90 95
CD 3   100 100

 

Science,Maths are values of the dimension Subject  while Term1 & Term2 are Measures. 

Labels (1)
1 Solution

Accepted Solutions
Or
MVP
MVP

You can control the order of the values vs. the dimensions by placing the value to the left or right of the values in the pivot definitions:

Or_0-1677674904987.png

 

View solution in original post

2 Replies
Or
MVP
MVP

You can control the order of the values vs. the dimensions by placing the value to the left or right of the values in the pivot definitions:

Or_0-1677674904987.png

 

Krish
Contributor III
Contributor III
Author

Worked like a charm. Thank you!!