topic Re: Handle Null Values in QlikView

Handle Null Values

kushalthakral — Tue, 13 May 2014 05:11:31 GMT

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 — Tue, 13 May 2014 05:15:53 GMT

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 — Tue, 13 May 2014 05:21:36 GMT

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 — Tue, 13 May 2014 05:28:07 GMT

Hi,

The below post might help you.

Regards

ASHFAQ