Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

maternmi
Contributor 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

Re: wrong syntax

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!

4 Replies
brijesh1991
Contributor III

Re: wrong syntax

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

Re: wrong syntax

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!

MVP
MVP

Re: wrong syntax

Hi,

Try like this

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

         *

;


Regards,

Jagan.

maternmi
Contributor II

Re: wrong syntax

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

Community Browser