topic How Can I Show a Date with in QlikView

How Can I Show a Date with

Sat, 10 Oct 2009 05:52:05 GMT

Hi guys!

I´m new, my name is John or Juan (as you like!) from Buenos Aires, Argentina. Excuse me but i have a bad english. i am interested in learn how i can show in differents tables dates i have recharged from an excel file. I want to make something like this

DATE

31 / 01 / 1987

04 / 12 / 2009

04 / 11 / 2009

YEAR

1987

2009

MONTH

DAY

CAN YOU HELP ME?

How Can I Show a Date with

prasad — Sat, 10 Oct 2009 09:06:51 GMT

Hi,

While loading date field, load as year(date field), month(date field), and day(date field).

after loading go the sheet where you want to display, select the year,month and day which can be displayed with the dimension you selected.

Prasad

How Can I Show a Date with

Sun, 11 Oct 2009 01:06:01 GMT

Thanks for this question but i have an error but i dont know where, can you help me?

ODBC CONNECT TO [Excel Files;DBQ=C:\Users\Pavilion\Desktop\Marcelo Ozan\T-CE-ACUM TOTAL AGO 07.xls];
SQL SELECT `date`,
FROM `C:\Users\Pavilion\Desktop\Marcelo Ozan\T-CE-ACUM TOTAL AGO 07`.`'CE-Acum07$'`;

LOAD
DAY ('date'),
MONTH ('date'),
YEAR ('date'),
FROM `C:\Users\Pavilion\Desktop\Marcelo Ozan\T-CE-ACUM TOTAL AGO 07`.`'CE-Acum07$'`;

thanks!!

How Can I Show a Date with

Sun, 11 Oct 2009 05:36:18 GMT

try this one ;


ODBC CONNECT TO [Excel Files;DBQ=C:\Users\Pavilion\Desktop\Marcelo Ozan\T-CE-ACUM TOTAL AGO 07.xls];
SQL SELECT `date`,
 FROM `C:\Users\Pavilion\Desktop\Marcelo Ozan\T-CE-ACUM TOTAL AGO 07`.`'CE-Acum07$'`;

LOAD
DAY ('date'),
MONTH ('date'),
YEAR ('date')
FROM `C:\Users\Pavilion\Desktop\Marcelo Ozan\T-CE-ACUM TOTAL AGO 07`.`'CE-Acum07$'`;

Your were getting an error because you were using comma end of your line in your query.

YEAR ('date'),

best regards,

Önder

How Can I Show a Date with

Anonymous — Mon, 12 Oct 2009 14:07:50 GMT

Hi,

You won't need the ODBC connection string or the whole SQL load in order to load an Excel file. This should be enough:

LOAD
DAY (date) as Day,
MONTH (date) as Month,
YEAR (date) as Year
FROM C:\Users\Pavilion\Desktop\Marcelo Ozan\T-CE-ACUM TOTAL AGO 07.xls (biff, embedded labels, table is CE-Acum07$);

This is if the field is named "date" in the Excel file. The easiest approach would be to use the button in the script editor called Table Files and just click your way to the Excel file and the load wizard will take you through creating the load statement.

How Can I Show a Date with

Mon, 12 Oct 2009 20:59:34 GMT

Excuse me, but i tried this and QV show me this

error in expresion: ')' expected

i have this script

SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='$ #.##0,00;$-#.##0,00';
SET TimeFormat='hh:mm:ss TT';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff] TT';
SET MonthNames='ene;feb;mar;abr;may;jun;jul;ago;sep;oct;nov;dic';
SET DayNames='lun;mar;mié;jue;vie;sáb;dom';

LOAD
DAY (comision desde) as Day,
MONTH (comision desde) as Month,
YEAR (comision desde) as Year
FROM C:\Users\Pavilion\Desktop\Marcelo Ozan\T-CE-ACUM TOTAL AGO 07.xls (biff, embedded labels, table is CE-Acum07$);

How Can I Show a Date with

Anonymous — Tue, 13 Oct 2009 09:41:03 GMT

Did you use the "Table File.." button to bring up the wizard? In this case I would think no because it looks like the problem is the name of the field, comision desde.

This should be enclosed with brackets, [comision desde]. Day ([comision desde]) as Day, etc.

When using the wizard it should encapsulate these by default.