Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
maternmi
Creator II
Creator II

wrong syntax


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

1 Solution

Accepted Solutions
Not applicable

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!

View solution in original post

4 Replies
brijesh1991
Partner - Specialist
Partner - Specialist

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

Not applicable

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!

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

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

         *

;


Regards,

Jagan.

maternmi
Creator II
Creator II
Author

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