Discussion Board for collaboration on QlikView Scripting.
I have a scenario as shown below:
Based on the "Usage Date" field in the Fact table I have to pick the Mapped Product in MappingTable.
So the End Table should look like:
Is there a way I can use ApplyMap to pass the UsageDate field as a parameter to use in the where clause and build a dynamic mapping table?
where From Date<=(VariableDate) and ToDate>=(VariableDate); //VariableDate is the Usage Date in Fact Table.
Also is there any other direction I need to go with to achieve this (preferably avoiding joins)?
Thanks in advance for your help!
Go to Solution.
You need to apply Interval Match Function instead of Apply Map , See demo attached.
Hope this helps you.
See the attached pdf
Thanks a lot Vikas, Mohit! This is exactly what I needed!