topic Re: IF quando data IS NOT NULL in Brasil https://community.qlik.com/t5/Brasil/IF-quando-data-IS-NOT-NULL/m-p/1396961#M50908 <HTML><HEAD></HEAD><BODY><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> OBRIGADO</P></BODY></HTML> Mon, 28 Aug 2017 18:43:26 GMT Ribeiro 2017-08-28T18:43:26Z IF quando data IS NOT NULL https://community.qlik.com/t5/Brasil/IF-quando-data-IS-NOT-NULL/m-p/1396959#M50906 <HTML><HEAD></HEAD><BODY><P>Tenho uma data no comando SQL</P><P>dbo.Movimento.<SPAN style="text-decoration: underline;"><STRONG>Data_Passou_Efetivacao_Estoque</STRONG></SPAN> IS NOT NULL</P><P></P><P>Gostaria de criar um if no&nbsp; Load Caso fosse nulo 0, caso não 1</P><P></P><P>if ( <SPAN style="font-size: 13.3333px;"><STRONG>Data_Passou_Efetivacao_Estoque</STRONG></SPAN><SPAN style="font-size: 13.3333px;"> <SPAN style="font-size: 13.3333px;">IS NOT NULL , 0,1)</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Não conseguir fazer alguma dica:</SPAN></P></BODY></HTML> Mon, 28 Aug 2017 18:03:03 GMT https://community.qlik.com/t5/Brasil/IF-quando-data-IS-NOT-NULL/m-p/1396959#M50906 Ribeiro 2017-08-28T18:03:03Z Re: IF quando data IS NOT NULL https://community.qlik.com/t5/Brasil/IF-quando-data-IS-NOT-NULL/m-p/1396960#M50907 <HTML><HEAD></HEAD><BODY><P>Se for em Qlik</P><P>If ( Isnull(<SPAN style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><STRONG style="font-style: inherit; font-size: 13.3333px; font-family: inherit;">Data_Passou_Efetivacao_Estoque</STRONG></SPAN><SPAN style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"> ),0,1)</SPAN></P></BODY></HTML> Mon, 28 Aug 2017 18:18:08 GMT https://community.qlik.com/t5/Brasil/IF-quando-data-IS-NOT-NULL/m-p/1396960#M50907 Clever_Anjos 2017-08-28T18:18:08Z Re: IF quando data IS NOT NULL https://community.qlik.com/t5/Brasil/IF-quando-data-IS-NOT-NULL/m-p/1396961#M50908 <HTML><HEAD></HEAD><BODY><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> OBRIGADO</P></BODY></HTML> Mon, 28 Aug 2017 18:43:26 GMT https://community.qlik.com/t5/Brasil/IF-quando-data-IS-NOT-NULL/m-p/1396961#M50908 Ribeiro 2017-08-28T18:43:26Z