How to Avoid Null Values like(-)?

[khasimvali85]

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.

[anbu1984]

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

[vikasmahajan]

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

[#4]

hope attached file will help you

[#5]

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.

[#6]

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

[#7]

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.

[khasimvali85]

Hi Simmons,

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

Regards,

Khasim.

[khasimvali85]

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.

[khasimvali85]

Hi Vikas,

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

Regards,

Khasim.