Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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!

11 Replies

Re: Show empty values in a pivot table

hi

     In dimensions - > tick show all values and in presentation tab ,untick suppress zero values..

Hope it helps

Not applicable

Re: Show empty values in a pivot table

It doesn't works, show the same thing.

Any other suggestion please?, I need to show that field

Re: Show empty values in a pivot table

Hi

     Can you post a sample file?

srikanthsri1
Valued Contributor

Re: Show empty values in a pivot table

just in presentation uncheck null values and in same at bootom where it show's null symbol keep '0'

Not applicable

Re: Show empty values in a pivot table

This is the example, regards!

Re: Show empty values in a pivot table

I dimension tab uncheck Suppress when value is null.

Not applicable

Re: Show empty values in a pivot table

No one of your answer works , look, I don't want to see the null values of the table, thats null values show the total values, or sumatory in this case, of all the employees that don't have a value on the existing fields. That is different of I want, to show the field "Transfer Unit", which has only null values, but that null values, for this field, not the total null of all employees, Am I explaining well?

Sorry for my english, it is still poor, regards.

Re: Show empty values in a pivot table

Hi

     That value is not map with any one of the field, so it doesn't appear in it. I think, this is the reason.

Re: Show empty values in a pivot table

Did you unchecked it(Suppress when value is null.) for both the dimensions?

Community Browser