topic Re: Work with null in QlikView https://community.qlik.com/t5/QlikView/Work-with-null/m-p/1385066#M421774 <HTML><HEAD></HEAD><BODY><P>What do you want to see exactly? Null values are not selectable nor you can exclude them from an expression (e.g.: set analysis) as they do not exist.</P><P></P><P>If those nulls come from the data and you don't need those lines for your analysis, use a JOIN function in the script so all fields are populated.</P></BODY></HTML> Tue, 14 Nov 2017 09:10:45 GMT Miguel_Angel_Baeyens 2017-11-14T09:10:45Z Work with null https://community.qlik.com/t5/QlikView/Work-with-null/m-p/1385065#M421773 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>How you exclude and include null value?</P><P>Example inclose.</P><P>@ !</P></BODY></HTML> Tue, 14 Nov 2017 09:02:40 GMT https://community.qlik.com/t5/QlikView/Work-with-null/m-p/1385065#M421773 ambasadorknz 2017-11-14T09:02:40Z Re: Work with null https://community.qlik.com/t5/QlikView/Work-with-null/m-p/1385066#M421774 <HTML><HEAD></HEAD><BODY><P>What do you want to see exactly? Null values are not selectable nor you can exclude them from an expression (e.g.: set analysis) as they do not exist.</P><P></P><P>If those nulls come from the data and you don't need those lines for your analysis, use a JOIN function in the script so all fields are populated.</P></BODY></HTML> Tue, 14 Nov 2017 09:10:45 GMT https://community.qlik.com/t5/QlikView/Work-with-null/m-p/1385066#M421774 Miguel_Angel_Baeyens 2017-11-14T09:10:45Z