topic Re: how to write not null in the set analysis in QlikView https://community.qlik.com/t5/QlikView/how-to-write-not-null-in-the-set-analysis/m-p/732516#M1084617 <HTML><HEAD></HEAD><BODY><P>Just say resolvedate = {"*"}</P></BODY></HTML> Tue, 24 Jun 2014 04:18:16 GMT 2014-06-24T04:18:16Z how to write not null in the set analysis https://community.qlik.com/t5/QlikView/how-to-write-not-null-in-the-set-analysis/m-p/732515#M1084616 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a requirement where in i have to add a condition like resolveddate is not null. Can someone help me how to implement this condition in the set analysis ASAP.</P><P></P><P>Thanks in advance,</P><P>Smitha</P><P><BR /> </P></BODY></HTML> Tue, 24 Jun 2014 04:15:50 GMT https://community.qlik.com/t5/QlikView/how-to-write-not-null-in-the-set-analysis/m-p/732515#M1084616 2014-06-24T04:15:50Z Re: how to write not null in the set analysis https://community.qlik.com/t5/QlikView/how-to-write-not-null-in-the-set-analysis/m-p/732516#M1084617 <HTML><HEAD></HEAD><BODY><P>Just say resolvedate = {"*"}</P></BODY></HTML> Tue, 24 Jun 2014 04:18:16 GMT https://community.qlik.com/t5/QlikView/how-to-write-not-null-in-the-set-analysis/m-p/732516#M1084617 2014-06-24T04:18:16Z Re: how to write not null in the set analysis https://community.qlik.com/t5/QlikView/how-to-write-not-null-in-the-set-analysis/m-p/732517#M1084618 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Filtering Null is a tricky part.</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">You can try {*} to select all values that should exclude the null value and - {''} should get rid of the blank values.</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">=sum({$&lt;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">resolveddate </SPAN>={'*'}-{''}&gt;} 1)</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Regards</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">ASHFAQ</P></BODY></HTML> Tue, 24 Jun 2014 04:28:31 GMT https://community.qlik.com/t5/QlikView/how-to-write-not-null-in-the-set-analysis/m-p/732517#M1084618 ashfaq_haseeb 2014-06-24T04:28:31Z