4 Replies Latest reply: Oct 14, 2015 3:16 AM by Teck Rul Saw RSS

    Combining Dimension

    Teck Rul Saw

      Hi Qlikers,

       

      Say, I have two sets of dates, 2 from different excel file. I wanted to have do this MonthName(Date([Date1])) union with MonthName(Date([Date2])).

       

      Example at excel file A

       

      ItemReceived Date
      AJune 2015
      ADecember 2015
      BDecember 2015

       

      Example at  excel file B

      Item Sent Out Date
      AOctober 2015
      ANovember 2015

       

      Such that, my dimension would have June 2015 to December 2015. How can I achieve that?