Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
khasimvali85
Creator II
Creator II

How to Avoid Null Values like(-)?

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.

1 Solution

Accepted Solutions
Not applicable

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

View solution in original post

19 Replies
anbu1984
Master III
Master III

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

vikasmahajan
Champion
Champion

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

Not applicable

hope attached file will help you

Not applicable

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.

Not applicable

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

Not applicable

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
Creator II
Creator II
Author

Hi Simmons,

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

Regards,

Khasim.

khasimvali85
Creator II
Creator II
Author

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
Creator II
Creator II
Author

Hi Vikas,

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

Regards,

Khasim.