topic Re: How to Avoid Null Values like(-)? in QlikView

How to Avoid Null Values like(-)?

khasimvali85 — Thu, 11 Dec 2014 03:23:29 GMT

Hi Community,

In my Application Showing null values like , whenever i select

-> Go to Chart Properties -> Select Dimension ->I Select Suppress where value is Null

when i select this the count of values showing wrong and select show all values the count of all values showing exact values, but in dimension showing Null Symbol how do i remove this null symbol?

see the attached files below mentioned.

Can anybody give me solution for this Null Values

waiting for reply

Regards,

Khasim.

Re: How to Avoid Null Values like(-)?

anbu1984 — Thu, 11 Dec 2014 05:40:26 GMT

Can you provide more details? By selecting which field do you get Nulls? Nulls in which field? Can you post sample app?

Re: How to Avoid Null Values like(-)?

vikasmahajan — Thu, 11 Dec 2014 06:34:24 GMT

you can give expression in calculated dimension and check values whether is null using if statement

=If(Len(Trim([DM_NAME])) = 0,'Unclassified',upper(Trim([DM_NAME])))

Hope this may help you

Regards

Vikas

Re: How to Avoid Null Values like(-)?

Thu, 11 Dec 2014 07:04:20 GMT

hope attached file will help you

Re: How to Avoid Null Values like(-)?

Thu, 11 Dec 2014 08:36:26 GMT

Whenever there's a null value in the dimensions, like in your case. write a if condition or alt.

Alt(Column_Name, 'Others') or if(Len(Column_Name)<1,'Others',Column_Name)

Its up to you what you put for the label.

Re: How to Avoid Null Values like(-)?

Thu, 11 Dec 2014 08:47:11 GMT

Hi Khas,

I would suggest looking at cleaning up your nulls in your script, rather than trying to do something on the front end.

Maybe have a look at this thread

http://community.qlik.com/docs/DOC-3155

hope that helps

Joe

Re: How to Avoid Null Values like(-)?

Thu, 11 Dec 2014 08:56:27 GMT

Creat a simple "Table Box" and sort by City Name.

Problem in the data if you reveal null values in Table Box.

If not, then problem in expressions.

Re: How to Avoid Null Values like(-)?

khasimvali85 — Thu, 11 Dec 2014 11:50:25 GMT

Hi Simmons,

Its Very Useful Document, and Thanks for sending the thread.

Regards,

Khasim.

Re: How to Avoid Null Values like(-)?

khasimvali85 — Thu, 11 Dec 2014 11:53:20 GMT

Hi Bhawna Gupta,

Thanks for Sending the file but In the Pivot Chart one Dimension showing Null, i want to hide this null .

Regards,

Khasim.

Re: How to Avoid Null Values like(-)?

khasimvali85 — Tue, 23 Dec 2014 10:51:02 GMT

Hi Vikas,

I don't want to show unclassified i want to show only my seven fields.

Regards,

Khasim.

Re: How to Avoid Null Values like(-)?

vikasmahajan — Tue, 23 Dec 2014 11:11:25 GMT

PFA SOULTION

VIKAS

Re: How to Avoid Null Values like(-)?

engishfaque — Tue, 23 Dec 2014 11:49:10 GMT

Dear Khasimvali85,

Here it is,

Alt(Field_Name, '-', 0) as FieldName

Kind regards,

Ishfaque Ahmed

Re: How to Avoid Null Values like(-)?

khasimvali85 — Tue, 23 Dec 2014 12:06:27 GMT

Hi Vikas,

Thanks For revert but i don't need another column in dimension'NOT AVAILABLE'.

Regards,

Khasim.

Re: How to Avoid Null Values like(-)?

Tue, 23 Dec 2014 12:34:43 GMT

Hi Khasim,

In order to suppress the null value, you need to tick "Suppress When Value is Null" in Dimensions Tab but the sum of PendingCallCount will show 17925 instead of 18103 in Subtotals row because you have some records where PendingCallCount has values without OrganizationBrand. Hope this explains.

Regards,

Sajeevan

Re: How to Avoid Null Values like(-)?

Tue, 23 Dec 2014 12:38:25 GMT

If you absolutely have to just supress the null but keep the total as the overall value, you could use dimensionality to sort this for you (I would recommend fixing the nulls though)

see attached

hope that helps

Joe

Re: How to Avoid Null Values like(-)?

khasimvali85 — Tue, 23 Dec 2014 12:41:05 GMT

hi Sajeevan,

Thanks for revert my calls count is 18103 for today from database also i have checked calls count.

when i am using chart objects i am getting null symbol. why i am getting this is there any reason?

Regards,

Khasim.

Re: How to Avoid Null Values like(-)?

khasimvali85 — Tue, 23 Dec 2014 12:48:01 GMT

Hi SImmons,

Thanks for this help its great.

Regards,

Khasim.

Re: How to Avoid Null Values like(-)?

Tue, 23 Dec 2014 13:01:00 GMT

Hi Khasim,

The reason was explained in my earlier reply. You have some records where PendingCallCount field has values but the OrganizationBrand field is empty (i.e. Null). You can check this by adding a Table box with these variables.

Regards,

Sajeevan

Re: How to Avoid Null Values like(-)?

khasimvali85 — Wed, 24 Dec 2014 02:44:58 GMT

Hi Sajeevan,

As you Said my Organization Brand field is not empty. i already checked, may be the problem is data showing null.

Regards,

Khasim.

Re: How to Avoid Null Values like(-)?

Wed, 24 Dec 2014 06:32:08 GMT

Hi Khasim,

You have 59593 rows of data in your table "AllIndiaReport".

Find below some stats I have produced out of your data to prove that the OrganizationBrand field is empty when PendingCallCount=1.

OrganizationBrand	Total Count	PendingCallCount=1
AC	1392	375
CLR	699	207
Focus India	14251	4170
Greather India SAN+KEL	11916	3411
Greather India VIDEOCON	22808	7778
KENSTAR	6182	1672
OTHER	1676	312

Non-Empty OrganizationBrand	58924	17925
Total Rows	59593	18103
Empty OrganizationBrand	-669	-178

Thanks,

Sajeevan