10 Replies Latest reply: Mar 19, 2014 3:54 PM by Tim Lathrop RSS

    If then statement?

    Tim Lathrop

      I have three tables.

      • Trade data
      • Published prices
      • Mapping table

      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.