Interval Match extended syntax

Wed, 11 Dec 2013 20:57:58 GMT

Alright, I am stumped. I have a table that uses a bunch of different calculations in order to assign each sales rep a value for several different KPIs. Then I have several Interval Match functions in order to calculate a corresponding bonus percentage value for each of the KPIs and then I essentially add all those percentage values up in order to calculate a final percentage, the Commission Amount. This originally worked fine, but now we want to pull in historical data, concatenate the old KPI numbers with the new, and be able to view Commission Amt by Sales Rep *and* MonthYear (not just snapshot in time as it was previously).

I tried some of the Interval Match Extended Syntax stuff, but didn't have much luck going that route. Any help would be appreciated!

Re: Interval Match extended syntax

Thu, 12 Dec 2013 14:56:22 GMT

Does anyone have any ideas? I am stuck.

Re: Re: Interval Match extended syntax

hic — Thu, 12 Dec 2013 20:24:17 GMT

You don't need the extended syntax.

KPI1Bridge:

IntervalMatch (KPI1)

Load KPI1Low, KPI1High

Resident KPI1Calc;

KPI2Bridge:

IntervalMatch (KPI2)

Load KPI2Low, KPI2High

Resident KPI2Calc;

HIC

topic Re: Interval Match extended syntax in QlikView

Interval Match extended syntax

Re: Interval Match extended syntax

Re: Re: Interval Match extended syntax