topic Re: wrong syntax in QlikView

wrong syntax

maternmi — Wed, 04 Dec 2013 07:53:14 GMT

Hello,

I have a problem with the following syntax. The systems says "missing or misplaced syntax" but I don't see the mistake.

Hope you can help me.

load if(isnull(Billing_Date) and today() > Erstes_Datum,'unreliable','check') as pickup reliability,

;

Thank you in advance!

Best regards,

Michael

Re: wrong syntax

brijesh1991 — Wed, 04 Dec 2013 07:57:12 GMT

load if((isnull(Billing_Date) and Date(today(),'DD/MM/YYYY') > Date(Erstes_Datum),'DD/MM/YYYY'),'unreliable','check') as pickup reliability // After applying above condition, even though you are getting error, then there is some date format issue. In that case, use makedate funtion to set your date in proper format. . .Regards, Brijesh

Re: wrong syntax

Wed, 04 Dec 2013 08:02:49 GMT

Hi Michael,

First thing that I noticed is pickup reliability should be either in brackets or with an underscore .

So, either [pickup reliability] or pickup_reliability should do.

If this does not solve the issue then you can look into date/time formats.

Hope this helps!

Re: wrong syntax

jagan — Wed, 04 Dec 2013 08:16:14 GMT

Hi,

Try like this

load if(isnull(Billing_Date) and today() > Erstes_Datum,'unreliable','check') as [pickup reliability],

;

Regards,

Jagan.

Re: wrong syntax

maternmi — Wed, 04 Dec 2013 08:42:25 GMT

Hi Shyamal,

Thank you! Very simple

I will post in the next few minutes onther issue, maybe you can help me.

I have three tables which contain fields which I need to create a new field but unfortunately I don't how to do it in the script I always get an syntetic key.

Best regards,

Michael