Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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.