Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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:
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:
Worked like a charm. Thank you!!