2 Replies Latest reply: Jul 21, 2015 6:33 AM by Philipp Schöck RSS

    Month and Year combined to a Date

    Philipp Schöck

      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?