topic Re: Zero and missing values in pivot in QlikView

Zero and missing values in pivot

Mon, 30 Mar 2015 14:36:39 GMT

Hi!

I have a table that is connected to another one.

When I create a pivot table for the first table I have something like this:

I mean I dont need this "-" values, cause it looks kinda ugly. I thing the reason is that my current table is connected to the other one.

I ticked "Suppress Zero values" and Suppress Missing, but it's still the same.

Any ideas why it can be like this?

robert_mika — Mon, 30 Mar 2015 14:40:34 GMT

I assume those are not 0 but NULL.

Try to use ISNULL in your load or IF(TRIM(LEN(yourfield))="".....

b_garside — Mon, 30 Mar 2015 14:41:38 GMT

The quickest solution is to try this... remove the hyphen shown below under the 'Presentation' Tab.

buzzy996 — Mon, 30 Mar 2015 15:06:13 GMT

are u applied on all ur dimensions in ur chart?,the same setting u mentioned this thread i.e "Suppress Zero values"!