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!!