topic Re: Difference between Null Symbol & Missing Symbol ? in QlikView

Difference between Null Symbol & Missing Symbol ?

Thu, 30 May 2013 05:02:42 GMT

Hi,

what is the difference between Null Symbol & Missing Symbol in the Presentation tab of St table and Pivot table ?

Thanks

Re: Difference between Null Symbol & Missing Symbol ?

tresB — Thu, 30 May 2013 05:20:34 GMT

By default, QlikView considers NULL values to be missing or undefined entities. However, certain database contexts imply that NULL values are to be considered as special values rather than simply missing values. The fact that NULL values are normally not allowed to link to other NULL values can be suspended by means of the NullAsValue statement.

Thanks.

Re: Difference between Null Symbol & Missing Symbol ?

er_mohit — Thu, 30 May 2013 05:50:54 GMT

In Pivot and Straight table the meaning is same for both

Null Symbol The symbol entered here will be used for displaying NULL values in the table.

Missing Symbol The symbol entered here will be used for displaying missing values in the

table.

You see the refrence manual or helps in qlikview for more details

hope it helps

Re: Difference between Null Symbol & Missing Symbol ?

Thu, 30 May 2013 06:10:16 GMT

the question is: what is the difference between NULL & MISSING ?

how do you differentiate ?

Re: Difference between Null Symbol & Missing Symbol ?

sushil353 — Thu, 30 May 2013 06:37:48 GMT

Hi,

Check out this white paper to understand the difference between NULL and MISSING Value.

HTH

Sushil