Apply Map Help

[Anonymous]

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...

[Gysbert_Wassenaar]

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

[sunny_talwar]

Which of the above three fields listed:[Effective Date], [Expired Date], [Unit Price] are coming from different tables?

[Anonymous]

effective date,expired date and unit price are all in the same table(Price Master) and Invoice Date Original is in different table.

[sunny_talwar]

Do you have a sample you can share?