topic Re: Date Object in Qlikview in QlikView

Date Object in Qlikview

Tue, 02 Dec 2014 07:17:16 GMT

Hi,

I have a column "DATE" with values as JAN 2011, APR 2012, AUG 1999.....etc.

I need to create a date object. Can anyone help me with this ?

its_anandrjs — Tue, 02 Dec 2014 07:19:30 GMT

Hi,

Which object you want to create.

Regards

Anand

Tue, 02 Dec 2014 07:21:45 GMT

question wrong pls check it once and come back

ashfaq_haseeb — Tue, 02 Dec 2014 07:37:20 GMT

Try like this

load *, date(date#(DateField,'MMM YYYY')) as Date ;

load * Inline

[

DateField

JAN 2011

APR 2012

AUG 1999

];

Regards

ASHFAQ

Tue, 02 Dec 2014 09:40:20 GMT

Actually, I m preparing a dashboard. In a table I have a Column called

DATE

Jan 1999

Apr 2000

etc.

I need to create a Date Object which displays, Month and year

vardhancse — Tue, 02 Dec 2014 10:07:20 GMT

create a date object with date field. u will see as expected

its_anandrjs — Tue, 02 Dec 2014 10:31:26 GMT

Create the master calendar for this and create the date field.

Regards

Anand