topic How to select null values? in QlikView https://community.qlik.com/t5/QlikView/How-to-select-null-values/m-p/255722#M96780 <HTML><HEAD></HEAD><BODY><P>I need to make selection of null values and check the data variation. So how should i do it in the script for the particular field?</P></BODY></HTML> Fri, 06 Jan 2012 07:06:03 GMT 2012-01-06T07:06:03Z How to select null values? https://community.qlik.com/t5/QlikView/How-to-select-null-values/m-p/255722#M96780 <HTML><HEAD></HEAD><BODY><P>I need to make selection of null values and check the data variation. So how should i do it in the script for the particular field?</P></BODY></HTML> Fri, 06 Jan 2012 07:06:03 GMT https://community.qlik.com/t5/QlikView/How-to-select-null-values/m-p/255722#M96780 2012-01-06T07:06:03Z How to select null values? https://community.qlik.com/t5/QlikView/How-to-select-null-values/m-p/255723#M96781 <HTML><HEAD></HEAD><BODY><P> Hi Priyanka, </P><P>You can use </P><P>If(IsNull(Field),'Null Value',Field) AS Field</P></BODY></HTML> Fri, 06 Jan 2012 07:15:18 GMT https://community.qlik.com/t5/QlikView/How-to-select-null-values/m-p/255723#M96781 vijay_iitkgp 2012-01-06T07:15:18Z Re: How to select null values? https://community.qlik.com/t5/QlikView/How-to-select-null-values/m-p/255724#M96782 <HTML><HEAD></HEAD><BODY><P>Or</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P>NullAsValue Field;</P><P>Set NullValue = 'Null Value';</P><P></P><P>// Make your final load here</P><P>Load</P><P>...</P><P>;</P><P></P><P>NullAsNull Field;</P></PRE><P></P><P>More performant than the If</P></BODY></HTML> Fri, 06 Jan 2012 07:35:57 GMT https://community.qlik.com/t5/QlikView/How-to-select-null-values/m-p/255724#M96782 nstefaniuk 2012-01-06T07:35:57Z