11 Replies Latest reply: Aug 6, 2012 5:47 AM by Pradip Sen RSS

    Show empty values in a pivot table

      Grettings, I have a problem.

       

      I have a pivot table, like this:

       

      Table.png

      In that that tabla I count the employees that have a termination reason, the count is Count(DISTINCT GlobalEmployeeId). It works perfectly, but, in the dimension Termination Reason, I have four fields, but the fourth,  Transfer Unit, isn't show because the numeric count is null, in other words, no one employee haves that termination reason. Then, Qlikview didn't show that field, and that's my problem, I need to show that field with zeros.

       

      Thanks you for help me, regards!