Is there an easy way to take a single date within a month and expand the value to the entire month? My to-be-added data has the first of each month and an associated monthly rate along with it. I want to join it with my existing data on a date field that spans the entire month.
A type of example...
Sales Date, Salesman, Merchandise Sold, Price
01/03/2016, John, Car, 10000
06/14/2017, Susan, Motorcycle, 12000
08/31/2014, Pam, Truck, 8000
2/1/2016, .03 ...
Since the commission rate is for the entire month I'd like to have .03 get associated with ALL of January 2016, .04 get associated with ALL of June 2017, etc. Short of doing a loop through all days in a month, is there an easy way or function for Qlikview to expand this?