topic MakeDate in QlikView

MakeDate

stephenedberkg — Tue, 28 Apr 2015 12:17:00 GMT

i have have the year and month filed i want to combine this year and month .

I am using

makedate(year,month,01) as date,

but this is not working can anyone help me?

Re: MakeDate

sunny_talwar — Tue, 28 Apr 2015 12:18:43 GMT

Maybe you need to use 1, instead of 01. Try this:

Date(MakeDate(year, month, 1), 'MM/DD/YYYY') as date,

Re: MakeDate

Anonymous — Tue, 28 Apr 2015 12:21:28 GMT

its working for me

dual(MakeDate(2011,01,3),'MMM/DD/YYYY')

Re: MakeDate

stephenedberkg — Tue, 28 Apr 2015 12:24:49 GMT

no it is not work

Re: MakeDate

anbu1984 — Tue, 28 Apr 2015 12:25:21 GMT

Do you have integer values or alphabets(Jan,Feb,..) in Month field?

Re: MakeDate

stephenedberkg — Tue, 28 Apr 2015 12:26:10 GMT

it is also not working for me

Re: MakeDate

sunny_talwar — Tue, 28 Apr 2015 12:27:33 GMT

You need integer values for year and month. If you don't have that, then you need to transform them into integers. For months you might be able to use a mapping load and applymap.

Best,

Sunny

Re: MakeDate

stephenedberkg — Tue, 28 Apr 2015 12:28:59 GMT

Alphabets(jan, feb )

Re: MakeDate

stephenedberkg — Tue, 28 Apr 2015 12:30:10 GMT

how to change alphabets to interger

Re: MakeDate

Anonymous — Tue, 28 Apr 2015 12:31:33 GMT

It's not going to work if you month field is string like Jan, Feb...

Try

date(date#(year & month, 'YYYYMMM'))

Re: MakeDate

Anonymous — Tue, 28 Apr 2015 12:31:42 GMT

Hi try this as sunindia suggested

Date(MakeDate(year, month, 1), 'MMM/DD/YYYY') as date,

Re: MakeDate

sunny_talwar — Tue, 28 Apr 2015 12:33:40 GMT

Months:

Mapping LOAD * Inline

[months, monthNo.

jan, 1

feb, 2

mar, 3

apr, 4

may, 5

jun, 6

jul, 7

aug, 8

sep, 9

oct, 10

nov, 11

dec, 12
];

MakeDate(year, ApplyMap('Months', month), 1) as date

Re: MakeDate

stephenedberkg — Tue, 28 Apr 2015 12:34:05 GMT

Already i tried but its not working

Re: MakeDate

anbu1984 — Tue, 28 Apr 2015 12:34:52 GMT

Makedate() need integer arguments and not alphabets. Try like this

Makedate(Year,Wildmatch(Month,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'),1) As Date

Re: MakeDate

stephenedberkg — Tue, 28 Apr 2015 12:40:04 GMT

yeah i got it

Re: MakeDate

stephenedberkg — Tue, 28 Apr 2015 12:42:41 GMT

yeah i got it. this is also correct.

thank you for your response

Re: MakeDate

stephenedberkg — Tue, 28 Apr 2015 12:43:23 GMT

thank a lot sunindia

Re: MakeDate

ankitaag — Tue, 28 Apr 2015 12:46:50 GMT

Hi Stehen,

Please convert your months to numbers.

Then use MakeDate(Year,Month,01)

Re: MakeDate

anbu1984 — Tue, 28 Apr 2015 12:49:49 GMT

If month field case doesn't match with mapping key, then you won't get result. Try Lower like this

MakeDate(year, ApplyMap('Months', Lower(month)), 1) as date

Re: MakeDate

Tue, 02 Jun 2015 08:40:40 GMT

no it should be like:

MakeDate(year, ApplyMap('Months', months), 1) as date