Handle Null Values

[kushalthakral]

Dear All

i have a following table

S.No	Details	01/01/2014	01/02/2014
1	A	21	20
2	B
3	C	3	2
4	D	2	2
5	E
6	F	12	23

I am loading above table using crosstable function but in report i am not able to show S.No 2 and S.no 5 because they have blank values

. So how i can show these values along with Details column like below

                             01/01/2014           01/02/2014

S.No     Details

1          A               21                         20

2          B                                            

3          C               3                           2

4          D               2                           2

5          E                   

6          F               12                         23

Thanks

Kushal Thakral

[kangaroomac]

Hiya,

In Properties, have you unticked the "Surpress Missing" check box?

Also, if you would like to show it as your sample, make the Null Symbol a space (also in the presentation tab).

[kushalthakral]

Hi Ian

i have already done all the settings but when u display it in pivot table Details column show blank where ever for S.No 5 has E Value

Regards

Kushal Thakral

[ashfaq_haseeb]

Hi,

The below post might help you.

http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/02/finding-null

http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/30/null-the-invisible-nothing

Regards

ASHFAQ