topic Re: deactivate NULL-Values in QlikView

deactivate NULL-Values

Tue, 27 Nov 2012 11:47:41 GMT

Hi,

I have a pivot table and I deactivated the Null-values in my second dimension. and my expression is sum(profit) and I would have 4 values in my first dimension and the first and second value do have some values that are connected to the second dimension. because the third and fourth vaue of dimension1 do not have data in dimension2 I cant see the last two datasets because of the deactivated null-values even though the expression does have a result.

does anyone know how I can hide all the 0 or Null values in the expression and not in the dimension?

regards,

Re: deactivate NULL-Values

Tue, 27 Nov 2012 12:02:24 GMT

It is like,

A B 1

A A 2

A c 3

A D 0

B A 1

B B 2

B C 3

B D 4

C - 1

D - 4

and if i deactivate the null values for dimension2 I cant see C,D(of dimenison1) at all it is completely gone

Re: deactivate NULL-Values

whiteline — Tue, 27 Nov 2012 13:34:40 GMT

Hi.

QV hides zeros in expressions by default.

Check 'Supress Zero-values' on Presentation tab.