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: 
Peony
Creator III
Creator III

How to highlight only first Totals row in the pivot table?

Hi all.
Please advise whether there are any options to highlight, in colour, only the very top Totals in a pivot table.
I have a table like the one below and tried to solve this issue using the Dimensionality() function. For some reason, my formula does not work. 
=If(Dimensionality() = 0,LightGray(), White())

Peony_0-1763571993007.png

 

Peony_1-1763572080749.png

 

 

Labels (2)
1 Solution

Accepted Solutions
Nagaraju_KCS
Specialist III
Specialist III

That should work, you have to write same expression in all the Dimensions and Measures for Background color expression

=If(Dimensionality() = 0, RGB(200, 200, 200), White())

Nagaraju_KCS_0-1763621290861.png

 

View solution in original post

3 Replies
marcus_sommer

It seems to be working - at least to Quarter - but you will probably need to set this customization to each column.

Nagaraju_KCS
Specialist III
Specialist III

That should work, you have to write same expression in all the Dimensions and Measures for Background color expression

=If(Dimensionality() = 0, RGB(200, 200, 200), White())

Nagaraju_KCS_0-1763621290861.png

 

Peony
Creator III
Creator III
Author

@Nagaraju_KCS you are right. Thank you.