Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

If then statement?

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.

10 Replies
Not applicable
Author

xoxo

Tim Lathrop

Fax: 1+ 832.251.8947

Mobile: 1+ 281.650.6901

www.Valprime.com