27 Replies Latest reply: Jul 18, 2016 4:30 AM by Anil Samineni RSS

    Background color for pivot table cells with MISSING values

    Valeriy Shylin

      Hi guys,


      I have a pivot table and an expression for setting cells' its background color. It's just RED(), unconditionally.

      Unfortunately, the MISSING values ignore my color and take the default one - white.


      It is possible to override the default color for the expression by setting CUSTOM FORMAT CELL. But that is not a solution when I have many expression which I want to color differently according to dimension values.


      The question is: how to make Qlikview consider the background color expression also for MISSING cells?


      Thanks in advance.