Expand A Pricing Date Table - Qlik Sense
Version 1, Dec 5, 2013

  Expand A Pricing Date Table - QlikView
Version 1, Dec 5, 2013

This example demonstrates using the Previous() function and WHILE clause to “fill in” values in a date range.

In this exercise, a transaction file provides Products, Prices, and the date the Price is effective.

The goal is to determine the Product Price for any given date.