Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using two tables price master which has following columns-
I made a key as Pricing key and used this expression in the front end->
=if([Invoice Date Original]>=[Effective Date] and [Invoice Date Original]<=[Expired Date],[Unit Price])
Price table
[Business Unit]&[2nd Item Number] as Pricing_key,
Location,
[Lot/SN],
[Effective Date],
[Expired Date],
[Unit Price]
This condition is working but it is giving me duplicate records with price as null so I do not wish to use join here and use apply map instead I want to compare the Invoice Date Original between effective and expiry date then I have to get the Unit Price.
any help with the code?
appreciate it...
I think what you're looking for is the IntervalMatch function. See this blog post: IntervalMatch. If you need more help then a qlikview document that demonstrates your problem will be helpful. See this document for how to create such a document: Preparing examples for Upload - Reduction and Data Scrambling
Which of the above three fields listed:[Effective Date], [Expired Date], [Unit Price] are coming from different tables?
effective date,expired date and unit price are all in the same table(Price Master) and Invoice Date Original is in different table.
Do you have a sample you can share?