Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
Partner - Champion III
Partner - Champion III

Use

Makedate(Year+2000, month, 1)

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

Not applicable
Author

Perfect many thanks