How to, IF do else don´t in script?

[#1]

Hi

I´m creating a Datekey by startdate & '_' & Enddate as Datekey

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?

/thanks!

[#2 · Accepted solution]

You could attach

WHERE (NOT ISNULL(startdate) or NOT ISNULL(enddate)) or

If the problem is with spaces you can also try:

WHERE LEN(TRIM(startdate))>0 or LEN(TRIM(enddate))>0.