topic Re: null values in QlikView

null values

Mon, 30 Nov 2015 08:06:27 GMT

Hi,

i am having raw data as below..

Feild1	Feild2	feild3
A	10	20
B	60	40
C
D

when i created the Pivot table, i can able to see only first two rows(A,B), remaining two rows are suppressed due to they are not containing values .

i want to see the C,D rows also if they do not have any values.

please help me on this.

Re: null values

Anonymous — Mon, 30 Nov 2015 08:24:24 GMT

Under Dimension Tab of Chart,

Dimension - > Uncheck Suppress when value is null and Check Show All Value

Re: null values

anlonghi2 — Mon, 30 Nov 2015 08:25:27 GMT

Hi Sowmya,

unselect "Suppress when value is null" for Field1 field from option from tab "Dimensions"

Best regards

Andrea

Re: null values

Anonymous — Mon, 30 Nov 2015 08:26:12 GMT

see the attachment

Re: null values

Mon, 30 Nov 2015 08:30:16 GMT

Hi Balraj,

thank you for the quick reply,

ya i have done that but still it is not showing te remaining rows.

it is showing the null values which are in A,B rows... not showing C,D rows..

any other help?

Re: null values

Mon, 30 Nov 2015 08:30:28 GMT

Hi,

Select Chart>>Properties>>Dimension>>Tick on "Show All Values" option.

and Deselect "Suppress When Value is NULL" option.

I think that should solve your problem.

Regards,

Re: null values

Mon, 30 Nov 2015 08:33:37 GMT

Hi Anlon,

thank you for the quick reply,

ya i have done that already,but it is not showing the remaining rows.

it is showing the null values which are in A,B rows... not showing C,D rows..

like....

Feild1	Feild2	feild3	feild4	feild5
A	10	20	10	0
B	60	40	0	20
C
D

any other help?

Re: null values

Siva_Sankar — Mon, 30 Nov 2015 08:49:44 GMT

find the attached file

Re: null values

Mon, 30 Nov 2015 08:57:55 GMT

Hi,

Select Chart >>Presentation >>Uncheck 'Suppress Zero-Value' Option.

Re: null values

Anonymous — Mon, 30 Nov 2015 09:33:52 GMT

May be useful this link ...

NULL handling in QlikView

Bye Angelo

Re: null values

Siva_Sankar — Mon, 30 Nov 2015 09:44:42 GMT

can you share your application?

Re: null values

Mon, 30 Nov 2015 12:17:36 GMT

Hey,

Yes is it possible for you to share the application?

HTH,

Re: null values

anlonghi2 — Mon, 30 Nov 2015 16:04:20 GMT

Ni Sowmya,

please look at attached qvw.

I loaded data from the attached excel.

To obtain your desired result I have unchecked "Suppress zero-values" from Presentation Tab.

Let me know

Best regards

Andrea