Search Recipes > While (1)

Expand A Pricing Date Table

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

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.

Share
Share

 

Recipes for Qlikview Success