Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to link date values to periods. I tried already a master calendar but with no result.
For contract I file a Reward% with a StartDate and In case of an ended contract also an EndDate in Excel.
How can I Link these differend values? So I can see which Reward% apply to a specific selected period. For excample August 2013.
I hopa someone can help me out.
Thanks in advance.
Dennis de Waal
Please look for IntervalMatch in the help.
Can you show us sample data with expected output?
go for interval match or show ur sample qvw application so we wil see
Here is the .qvw with the Excel source.
See more in this blog post:
http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/04/intervalmatch
HIC