topic Handling missing symbols in QlikView https://community.qlik.com/t5/QlikView/Handling-missing-symbols/m-p/146484#M25033 <HTML><HEAD></HEAD><BODY><P>You could try this:</P><P>rangemax(0,count(distinct field_name))</P><P>But I don't know why what you said wouldn't work. Well, unless you're using 64-bit, which has issues with isnull(). If that's the problem, use len(...)&gt;0.</P><P>Another option might be to make your null symbol be 0 and right justify it in the cell.</P></BODY></HTML> Thu, 11 Jun 2009 03:28:45 GMT johnw 2009-06-11T03:28:45Z Handling missing symbols https://community.qlik.com/t5/QlikView/Handling-missing-symbols/m-p/146483#M25032 <HTML><HEAD></HEAD><BODY><P>Hi, everybody,</P><P>I have a problem with missing symbol in QV chart. I use formula "Count(distinct field_name) " in my chart expression and for those cells wich are missing, I would like to see 0 (as number). Is it possible to achieve?<BR />I tried methods IF(IsNULL(Count(distinct field_name)), 0, Count(distinct field_name)), but this does not work.</P><P>Thanks for you help,<BR />Ramunas</P><P></P></BODY></HTML> Thu, 11 Jun 2009 01:29:41 GMT https://community.qlik.com/t5/QlikView/Handling-missing-symbols/m-p/146483#M25032 2009-06-11T01:29:41Z Handling missing symbols https://community.qlik.com/t5/QlikView/Handling-missing-symbols/m-p/146484#M25033 <HTML><HEAD></HEAD><BODY><P>You could try this:</P><P>rangemax(0,count(distinct field_name))</P><P>But I don't know why what you said wouldn't work. Well, unless you're using 64-bit, which has issues with isnull(). If that's the problem, use len(...)&gt;0.</P><P>Another option might be to make your null symbol be 0 and right justify it in the cell.</P></BODY></HTML> Thu, 11 Jun 2009 03:28:45 GMT https://community.qlik.com/t5/QlikView/Handling-missing-symbols/m-p/146484#M25033 johnw 2009-06-11T03:28:45Z