topic Re: Month Year in QlikView

Month Year

Thu, 29 Oct 2015 19:42:03 GMT

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 — Thu, 29 Oct 2015 19:48:11 GMT

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

Convert in QlikView

Month(datum) as Month

in script.

chancekbarkley — Thu, 29 Oct 2015 19:54:20 GMT

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.

Thu, 29 Oct 2015 19:58:46 GMT

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

i have select Month(dateintroduction) as Month from users

gives me a failure;

Thu, 29 Oct 2015 20:10:39 GMT

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 — Thu, 29 Oct 2015 20:42:25 GMT

LOAD *, Month(datum) AS Month;

SQL select datum, carslicense FROM table