Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Month and Year combined to a Date

Hi all,

I have a problem.

I have a order_table, there are 2 columns one for months and one for years in the format like this:

monthyear
113
113
213
314

I want to combine that columns to one, called 'order_date' but qlikview do not recognice that this numbers are dates.

But I need this, to combine it with my master_calendar.

Any ideas?

2 Replies

Re: Month and Year combined to a Date

Use

Makedate(Year+2000, month, 1)

to build a date starting from year and month ...

Not applicable

Re: Month and Year combined to a Date

Perfect many thanks

Community Browser