topic Re: Apply Map Help in QlikView

Apply Map Help

Anonymous — Fri, 10 Jul 2015 12:35:09 GMT

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

Re: Apply Map Help

Gysbert_Wassenaar — Fri, 10 Jul 2015 12:53:38 GMT

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

Re: Apply Map Help

sunny_talwar — Fri, 10 Jul 2015 12:55:03 GMT

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

Re: Apply Map Help

Anonymous — Sun, 12 Jul 2015 05:57:01 GMT

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

Re: Apply Map Help

sunny_talwar — Sun, 12 Jul 2015 06:00:35 GMT

Do you have a sample you can share?