Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
swati_rastogi27
Contributor

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
Valued Contributor

Re: Color of last/Totals row in a straight table

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

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

thornofcrowns
Valued Contributor II

Re: Color of last/Totals row in a straight table

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
Contributor

Re: Color of last/Totals row in a straight table

Hi ,

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

luciancotea
Valued Contributor

Re: Color of last/Totals row in a straight table

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!

Highlighted
Chanty4u
Esteemed Contributor III

Re: Color of last/Totals row in a straight table