Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
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