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

Hi,


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.

  • 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

Login or Signup to post a comment