Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Can you provide more details? By selecting which field do you get Nulls? Nulls in which field? Can you post sample app?
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
hope attached file will help you
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.
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
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.
Hi Simmons,
Its Very Useful Document, and Thanks for sending the thread.
Regards,
Khasim.
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.
Hi Vikas,
I don't want to show unclassified i want to show only my seven fields.
Regards,
Khasim.