topic Where is my error? in QlikView

Where is my error?

Thu, 15 Oct 2009 02:15:02 GMT

Hi! I'm new using QV. I have to show the field "FECHA DESDE" in three columns (Day, Month and Year). I wrote this script

LOAD [FECHA DESDE],
DAY (FECHA DESDE)
MONTH (FECHA DESDE),
YEAR (FECHA DESDE),
FROM [PERSONAL\comision desde.xls] (biff, embedded labels, table is [PersonalCOMP$]);

But i have an error like this: error in expresion: ')' expected

How can i do to fix this?

Thanks!!

Where is my error?

biester — Thu, 15 Oct 2009 02:20:07 GMT

1. Use the square brackets also in the day, month and year functions, e.g.:

DAY([FECHA DESDE]) ....

2. after the DAY(..) in your post ther is no comma .. of course ther must be one

Perhaps this helps.

Rgds,
Joachim

Where is my error?

Thu, 15 Oct 2009 02:21:09 GMT

Try this

LOAD [FECHA DESDE],
DAY ([FECHA DESDE])
MONTH ([FECHA DESDE]),
YEAR ([FECHA DESDE]),
FROM [PERSONAL\comision desde.xls] (biff, embedded labels, table is [PersonalCOMP$]);

Talha

Where is my error?

Thu, 15 Oct 2009 02:52:48 GMT

Thanks Joachim and Talha but when i tried that i have a sintax error like this:

Sintax Error. Clause FROM displaced or Clause FROM didnt find. (excuse me for my english!)

Where is my error?

biester — Thu, 15 Oct 2009 02:54:45 GMT

Remove the comma behind the YEAR() ...(just before the FROM).

Rgds,
Joachim

Where is my error?

prieper — Thu, 15 Oct 2009 03:36:39 GMT

... and add one comma after DAY([FECHA DESDE])

Peter

Where is my error?

biester — Thu, 15 Oct 2009 03:40:11 GMT

... as I suggested in my first reply.

Where is my error?

Thu, 15 Oct 2009 03:40:54 GMT

THANKS FOR ALL. I CAN DO IT .... this is de correct script:

directory;
Load
DAY ([FECHA DESDE]) as [DAY DESDE],
MONTH ([FECHA DESDE]) as [MONTH DESDE],
YEAR ([FECHA DESDE]) as [YEAR DESDE]
FROM (biff, embedded labels, table is [PersonalCOMP$]);

THANKS!