Apply different style for last row or column of table generated in excel v3.0.4

Posted almost 3 years ago by Michael Sattler

Post a topic
Un Answered
Michael Sattler


In the Mail & Deploy Designer when designing an excel report,

is it possible to check via an expression  if a certain cell is in the last row or column of my exce table?

I know this expression works for checking if the cell is in the first row of my excel table:

if([RowNumber] = 1, RGB(192,192,192),RGB(255,255,255)) 


Now i need an expression like this to work:

if([RowNumber] = NUMBER_OF_ROWS, rgb(192,192,192),rgb(255,255,255)) 


Also, the expression should work for different Pivot tables so it shouldn't reference a perticular  datasource object.

0 Votes


Emma Camacho

Emma Camacho posted almost 3 years ago Admin

Hi Michael,

This is a very cool feature request (to have it out of the box).

In the meantime, you could get the count of rows using a Qlik expression!

kind regards, Emma

0 Votes

Login or Sign up to post a comment