6 Replies Latest reply: Aug 29, 2012 5:41 PM by Michael Pierson RSS

    Create a date variable using variables within my original data

      Hi,

       

      My data set has variables called month and year, I would like to combine these with the day being equal to 1 in order to make a date. The reason behind this is so that I can then use the time series graphs to be able to properly compare time periods over the last 5 years (as an example).

       

      I was trying to do this within the script editor but I'm not sure of the syntax. I know how to create this in excel (or SAS code), I'm just not quite there yet with Qlikview!

       

      Alternatively, if there is an easier way, I'm open to all advice!!

       

      Thanks in advance!

      Rob