Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to link StartDate and EndDate to periods?

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

5 Replies
Not applicable

Re: How to link StartDate and EndDate to periods?

Please look for IntervalMatch in the help.

anbu1984
Honored Contributor III

Re: How to link StartDate and EndDate to periods?

Can you show us sample data with expected output?

Not applicable

Re: How to link StartDate and EndDate to periods?

go for interval match or show ur sample qvw application so we wil see

Not applicable

Re: How to link StartDate and EndDate to periods?

Here is the .qvw with the Excel source.

Employee
Employee

Re: How to link StartDate and EndDate to periods?

Community Browser