Month Year

[#1]

Hello,

I have a date field in Oracle and transformed this.

TO_CHAR(datum,'mon') Month

then i select Month in select box.

Now i don't get the chronical order.

How can I fix this?

[MK_QSL]

Keep datum in same format.. .Dont convert it.

Convert in QlikView

Month(datum) as Month

in script.

[chancekbarkley · Accepted solution]

Rather than extract the month int he SQL Select, use qlik script in the preceding load.  Month(datum) AS Month.

LOAD      Month(datum) AS Month
SQL       SELECT *
          FROM table

It should then sort correctly.

[#4]

it doesn't work; i make connection to oracle database

i have select Month(dateintroduction) as Month from users

gives me a failure;

[#5]

i need also other columns in table

does i need to specify them in load

e.g

LOAD Month(datum) AS Month

SQL select datum, carslicense

FROM table

does this work?

[MK_QSL]

LOAD *, Month(datum) AS Month;

SQL select datum, carslicense FROM table