Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
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
alexandros17
Employee
Employee

Use

Makedate(Year+2000, month, 1)

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

Not applicable
Author

Perfect many thanks