topic Loading data in QlikView

Loading data

Wed, 06 Jun 2012 13:38:39 GMT

Hello how can i load the date of my field as "year-month"? It's know "day-month-year"

Loading data

jagan — Wed, 06 Jun 2012 13:43:26 GMT

Hi,

Use this

=Date(DateFieldName, 'YYYY-MMM')

Regards,

Jagan.

Loading data

CELAMBARASAN — Wed, 06 Jun 2012 13:47:30 GMT

Hi,

Check with this if jagan mohan suggestion is not working.

Date(Date#(DateField,'DD-MMM-YYYY'),'YYYY-MMM')

Loading data

Wed, 06 Jun 2012 14:31:38 GMT

Does'nt work returns '0'

Loading data

Wed, 06 Jun 2012 14:32:58 GMT

Returns '-1'

Loading data

jagan — Wed, 06 Jun 2012 14:35:19 GMT

Hi,

Can you attach some sample dates you used in the application. When I checked this '05/01/2012' I got

=Date('5/1/2012', 'YYYY-MMM')

2012-May

Regards,

Jagan.

Loading data

CELAMBARASAN — Wed, 06 Jun 2012 14:39:21 GMT

Hi,

Can you post sample date format you have used in these expressions?

Celambarasan

Loading data

Wed, 06 Jun 2012 14:45:24 GMT

The date which is loaded is know 1-5-2012 and i want 2012-5

Loading data

jagan — Wed, 06 Jun 2012 14:48:14 GMT

Hi,

Try this

Date(Date#(DateField,'D-M-YYYY'),'YYYY-M')

Regards,

jagan.

Loading data

CELAMBARASAN — Wed, 06 Jun 2012 14:48:30 GMT

Hi,

Then check with this
Date(Date#(DateField,'D-M-YYYY'),'YYYY-M')

Celambarasan

Loading data

Wed, 06 Jun 2012 14:56:14 GMT

Again 0

Loading data

Wed, 06 Jun 2012 14:58:59 GMT

I used this in the script and it returns again 0

STARTDATUM = Date(Date#(STARTDATUM,'D-M-YYYY'),'YYYY-M'),

Re: Loading data

jagan — Wed, 06 Jun 2012 15:00:09 GMT

Hi,

Check file attached. The same expression works for me. Can you attach sample file you are working.

Regards,

Jagan.