topic Re: Syntax error in QlikView

Syntax error

Anonymous — Fri, 19 Sep 2014 07:34:49 GMT

Hello,

What is wrong with this syntax??

=sum(if(Clearing_AUGDT >'31/Jan/2014' and [Posting Date_BUDAT]<='31/Jan/2014' , ([Amount in LC_DMBTR])))

Why its not working?

Please suggest.

Regards,

Balraj

Re: Syntax error

tresB — Fri, 19 Sep 2014 07:38:06 GMT

One reason could be mismatch in date format

Re: Syntax error

Fri, 19 Sep 2014 07:41:06 GMT

Hi Balraj,

You can try this

=Sum(if((Date(Clearing_AUGDT,'DD/MMM/YYY')>Date('31/Jan/2014','DD/MMM/YYY)) and (Date([Posting Date_BUDAT],DD/MMM/YYY')<=Date(31/Jan/2014',DD/MMM/YYY')), ([Amount in LC_DMBTR]),0))

Re: Syntax error

jyothish8807 — Fri, 19 Sep 2014 07:54:54 GMT

Its better to change it into date format in script, so that it works properly in all tables and expression.

In script:

Load

Date(Clearing_AUGDT,'DD/MM/YYYY') as Clearing_AUGDT,

Date([Posting Date_BUDAT],'DD/MM/YYYY') as Posting Date_BUDAT

from.....................;

After this try the same script you used.Hope this help.

Regrds

Re: Syntax error

Anonymous — Fri, 19 Sep 2014 08:13:02 GMT

not working

Re: Syntax error

jagan — Fri, 19 Sep 2014 08:15:43 GMT

Hi,

Attach sample file so that it would be easier to check.

Regards,

Jagan.

Re: Syntax error

Anonymous — Fri, 19 Sep 2014 08:22:40 GMT

=sum({$<Clearing_AUGDT ='>''31/Jan/2014', [D/CIndicator]={'S'}>} [Amount in LC_DMBTR])

Could you tell what is the syntax error?

Re: Syntax error

Fri, 19 Sep 2014 08:33:23 GMT

From the field names (BUDAT), it seems you are working with SAP data. The dates in SAP are anyway trickier to work with. Check from qvd in what format the date is being stored and has the QV app recognised it as a date format.

One of the initial tests can be to check in a text box if a Num operation on the date field gives the correct number corresponding to that date.

Re: Syntax error

tresB — Fri, 19 Sep 2014 08:34:17 GMT

Correct syntax:

=sum({$<Clearing_AUGDT ={'>31/Jan/2014'}, [D/CIndicator]={'S'}>} [Amount in LC_DMBTR])

Re: Syntax error

jyothish8807 — Fri, 19 Sep 2014 08:34:22 GMT

''31/Jan/2014' is the error

=sum({$<Clearing_AUGDT ={'>31/Jan/2014'}, [D/CIndicator]={'S'}>} [Amount in LC_DMBTR])

Try this.