Interval Matching & Cumulative Calculations

Fri, 25 Feb 2011 15:53:02 GMT

Dear All,

I hope someone can help with my problem. I have attached an example application for info.

I have two contracts

Contract A £2,000,000

Contract B £4,000,000

for which I need to calculate the monthly revenue (by the number of days in each month). This on the face of it seems straight forward.

Where it gets slightly complicated is that each contract has an annual increase (CPA) each year from a specific date -

Contract A 25-Oct-2010 & 25-Oct-2011

Contract B 17-Feb-2010 & 08-Feb-2011

My problem is multi fold -

(1) My interval match doesn't seem to work so when I am trying to match the CPA (contract increase) date against the month it appears it, it doesn't recognise it.

(2) Where I want to calculate the value of the increase it only shows the value for the one month, whilst I want to calculate the cumulative position.

(3) I only want to calculate the revenue increase for contracts where the CPA (contract increase) date is after 1 September 2010.

Please let me know your thoughts folks !

Interval Matching & Cumulative Calculations

Fri, 25 Feb 2011 16:34:04 GMT

Application attached.

topic Interval Matching & Cumulative Calculations in QlikView

Interval Matching & Cumulative Calculations

Interval Matching & Cumulative Calculations