Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
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
Highlighted
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())

Highlighted
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.

Highlighted
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

Highlighted
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
Esteemed Contributor III

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