topic How to, IF do else don´t in script? in QlikView https://community.qlik.com/t5/QlikView/How-to-IF-do-else-don-t-in-script/m-p/360308#M133807 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I´m creating a Datekey by startdate &amp; '_' &amp; Enddate as Datekey</P><P></P><P>but some of my post are corrupt and don´t have either start or enddate. I think qlikview then just give me a _ in the datekey field. When there are no start/enddate I would like qw to just move one and not construct a datekey. How is this done?</P><P></P><P>/thanks!</P></BODY></HTML> Tue, 20 Mar 2012 16:46:34 GMT 2012-03-20T16:46:34Z How to, IF do else don´t in script? https://community.qlik.com/t5/QlikView/How-to-IF-do-else-don-t-in-script/m-p/360308#M133807 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I´m creating a Datekey by startdate &amp; '_' &amp; Enddate as Datekey</P><P></P><P>but some of my post are corrupt and don´t have either start or enddate. I think qlikview then just give me a _ in the datekey field. When there are no start/enddate I would like qw to just move one and not construct a datekey. How is this done?</P><P></P><P>/thanks!</P></BODY></HTML> Tue, 20 Mar 2012 16:46:34 GMT https://community.qlik.com/t5/QlikView/How-to-IF-do-else-don-t-in-script/m-p/360308#M133807 2012-03-20T16:46:34Z How to, IF do else don´t in script? https://community.qlik.com/t5/QlikView/How-to-IF-do-else-don-t-in-script/m-p/360309#M133808 <HTML><HEAD></HEAD><BODY><P>You could attach </P><P>WHERE (NOT ISNULL(startdate) or NOT ISNULL(enddate)) or </P><P></P><P>If the problem is with spaces you can also try:</P><P>WHERE LEN(TRIM(startdate))&gt;0 or LEN(TRIM(enddate))&gt;0.</P></BODY></HTML> Tue, 20 Mar 2012 19:12:08 GMT https://community.qlik.com/t5/QlikView/How-to-IF-do-else-don-t-in-script/m-p/360309#M133808 2012-03-20T19:12:08Z