I want to add the appropriate published price to the trade data table when I select the specific published date. When I select the appropriate published date in Qlikview the system populates the most current price. I want the published price to be tied to the range begin date.
Something like this:
If Range begin is < or = published price date then use range date as published price date and return published price for that date.
