Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
swati_rastogi27
Creator
Creator

Color of last/Totals row in a straight table

Can anyone help me with setting the color if the mast row in my straight table?

Basically I have a straight table with expressions and the last row is of totals.

I want the row to be highlighted in different color and font.

5 Replies
luciancotea
Specialist
Specialist

Click on the plus sign of the expression and edit the "Background Color" and "Text Color" using Dimensionality() function:

=if(Dimensionality() = 0, red())

ThornOfCrowns
Specialist II
Specialist II

Following on from the above answer, you can change background and font colour, as well as weight and size, but you can't change the font itself.

swati_rastogi27
Creator
Creator
Author

Hi ,

I want to change the background color of only the last row of my straight table and the header row

luciancotea
Specialist
Specialist

Looks like you want custom coloring of your straight table:

1. Select View -> Design Grid

2. Right-click on the straight table and select "Custom Format Cell"

Enjoy!