27 Replies Latest reply: Jul 18, 2016 4:30 AM by Anil Babu 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.

       

      Valera