topic Re: NULL VALUES in QlikView https://community.qlik.com/t5/QlikView/NULL-VALUES/m-p/881198#M1233547 <HTML><HEAD></HEAD><BODY><P>Thank you very much for the help.</P><P></P><P>It worked to perfection!</P></BODY></HTML> Fri, 29 May 2015 21:07:46 GMT 2015-05-29T21:07:46Z NULL VALUES https://community.qlik.com/t5/QlikView/NULL-VALUES/m-p/881196#M1233543 <HTML><HEAD></HEAD><BODY><P>Hello everyone.</P><P></P><P>I have a problem with a null value, have an if statement where a comparison: if over 90 that puts "certified" if less than you put "non-certified" but if my field is empty (that is a base Excel) to make without information. In what way I can represent that it is null or empty field.</P><P></P><P>I only know this way, '' but it is not taking into account as null, how could you do to show "No information"?</P></BODY></HTML> Mon, 26 Jan 2026 16:26:21 GMT https://community.qlik.com/t5/QlikView/NULL-VALUES/m-p/881196#M1233543 2026-01-26T16:26:21Z Re: NULL VALUES https://community.qlik.com/t5/QlikView/NULL-VALUES/m-p/881197#M1233545 <HTML><HEAD></HEAD><BODY><P>See if this helps:</P><P>if(len(trim(Field))=0, 'No Information', if(Field&gt;90, 'Certified', 'Non-Certified'))</P></BODY></HTML> Fri, 29 May 2015 20:43:43 GMT https://community.qlik.com/t5/QlikView/NULL-VALUES/m-p/881197#M1233545 Anonymous 2015-05-29T20:43:43Z Re: NULL VALUES https://community.qlik.com/t5/QlikView/NULL-VALUES/m-p/881198#M1233547 <HTML><HEAD></HEAD><BODY><P>Thank you very much for the help.</P><P></P><P>It worked to perfection!</P></BODY></HTML> Fri, 29 May 2015 21:07:46 GMT https://community.qlik.com/t5/QlikView/NULL-VALUES/m-p/881198#M1233547 2015-05-29T21:07:46Z