topic Re: Show empty values in a pivot table in QlikView

Show empty values in a pivot table

Thu, 02 Aug 2012 16:47:26 GMT

Grettings, I have a problem.

I have a pivot table, like this:

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!

Re: Show empty values in a pivot table

MayilVahanan — Thu, 02 Aug 2012 16:55:38 GMT

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

Hope it helps

Re: Show empty values in a pivot table

Thu, 02 Aug 2012 18:51:41 GMT

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

MayilVahanan — Thu, 02 Aug 2012 19:44:48 GMT

Can you post a sample file?

Re: Show empty values in a pivot table

Anonymous — Thu, 02 Aug 2012 20:00:15 GMT

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

Re: Show empty values in a pivot table

Fri, 03 Aug 2012 16:28:00 GMT

This is the example, regards!

Re: Show empty values in a pivot table

CELAMBARASAN — Fri, 03 Aug 2012 16:58:14 GMT

I dimension tab uncheck Suppress when value is null.

Re: Show empty values in a pivot table

Fri, 03 Aug 2012 17:22:03 GMT

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

MayilVahanan — Fri, 03 Aug 2012 17:58:31 GMT

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

CELAMBARASAN — Fri, 03 Aug 2012 20:26:12 GMT

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

Re: Show empty values in a pivot table

rajni_batra — Mon, 06 Aug 2012 09:03:36 GMT

Uncheck Suppress when value is null from MONTH Dimension..

Hope it Helps!!!

Re: Show empty values in a pivot table

senpradip007 — Mon, 06 Aug 2012 09:47:21 GMT

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

Uncheck Suppress when value is null from MONTH Dimension

Hope it helps