Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
deep2021
Creator III
Creator III

Verical names in QS pivot table

Hi,

 

Can you please suggest how to show names like below in QS pivot table.

deep2021_1-1717001284438.png

 

Also, Can you please suggest how to changes the font?

 

Thanks.

 

Labels (5)
5 Replies
MatheusC
Specialist II
Specialist II

@deep2021 

You can try to insert it through CSS in the multi KPI.

// Rotate the header label
th.cell.ng-scope.header.top span.ng-binding {
        writing-mode: tb-rl;
        transform: rotate(-150deg);     
}

// change the label style
.qv-pt .cell.header.top {
        font-weight: bold;
         font-family: ‘Roboto’, sans-serif;        
}

// hide the multi KPI chart
.qv-object-qlik-multi-kpi {
display: none;
}

test result

MatheusC_1-1717007163901.png

 



And from the chart customization, there is also font size and color customization, depending on your version it may already be available.

MatheusC_0-1717007089309.png



Regarts, Matheus

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
deep2021
Creator III
Creator III
Author

But how the below code will work from multi kpi and reflect the changes in QS pivot table?

// Rotate the header label
th.cell.ng-scope.header.top span.ng-binding {
        writing-mode: tb-rl;
        transform: rotate(-150deg);     
}

// change the label style
.qv-pt .cell.header.top {
        font-weight: bold;
         font-family: ‘Roboto’, sans-serif;        
}

// hide the multi KPI chart
.qv-object-qlik-multi-kpi {
display: none;
}


It is not working
MatheusC
Specialist II
Specialist II

@deep2021 
1 - Create a multi-KPI chart on custom objects.
2 - Add a representative measure to the KPI, for example, fx=1

MatheusC_0-1717088767021.png

 


3 - Finally, enter the CSS code provided in the “Style” tab of the multi-KPI chart to apply it to the pivot table chart.

MatheusC_1-1717088811261.png


Note: If you’re using the new pivot table in custom objects, the tag mentioned in this code won’t work. Let me know if it worked!

Regarts, Matheus



Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
deep2021
Creator III
Creator III
Author

This is not working for me.

Thanks

MatheusC
Specialist II
Specialist II

see my example in qvf

health!

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!