topic Interval Match in QlikView

Interval Match

Thu, 21 Jun 2012 20:59:30 GMT

I am trying to use intevalmatch function, but using the help I couldn't.

ScaleBudget:

LOAD * Inline

[

From,To,CodBudget

0,3499,1

3500,6999,2

7000,10499,3

10500,15999,4

16000,19999,5

20000,1000000000,6

];

Budget:

LOAD

Budget

FROM

$(Path_QVD)Budget.QVD (qvd);

IntervalMatch1:

IntervalMatch(Budget)

LOAD

From,

Resident ScaleBudget;

As I understood I could do a left join to get a table with the Budget and the CodBudget inline ...

Thanks in advance.,

Re: Interval Match

MayilVahanan — Thu, 21 Jun 2012 21:32:14 GMT

Hi,

Try this,

ScaleBudget:

LOAD * Inline

[

From,To,CodBudget

0,3499,1

3500,6999,2

7000,10499,3

10500,15999,4

16000,19999,5

20000,1000000000,6

];

Budget:

LOAD

Budget

FROM

$(Path_QVD)Budget.QVD (qvd);

IntervalMatch1:

Left Join(Budget)

IntervalMatch(Budget)

LOAD

From,

Resident ScaleBudget;

Hope it helps,

Re: Interval Match

Fri, 22 Jun 2012 17:36:28 GMT

no, it doesn't work

Re: Interval Match

Miguel_Angel_Baeyens — Fri, 22 Jun 2012 19:57:00 GMT

Hi,

Check this code. Note that QlikView is case sensitive, and note the names of the tables in the example.

Hope that helps.

Miguel

Re: Interval Match

chematos — Fri, 22 Jun 2012 20:33:19 GMT

ScaleBudget_Temp:

LOAD * Inline

[

From,To,CodBudget

0,3499,1

3500,6999,2

7000,10499,3

10500,15999,4

16000,19999,5

20000,1000000000,6

];

ScaleBudget:

LOAD

From as Min,

To as Max

resident ScaleBudget_Temp;

Budget:

LOAD

Budget

FROM

$(Path_QVD)Budget.QVD (qvd);

IntervalMatch1:

IntervalMatch(Budget)

LOAD

Min,

Max

Resident ScaleBudget;

Left Join(ScaleBudget)

LOAD

From as Min,

To as Max,

CodBudget

Resident ScaleBudget_Temp;

Drop Table ScaleBudget_Temp;

Rename Field Min as From;

Rename Field Max as To;

Or you could drop fields min and max if you don´t need.

Drop Fields Min,Max from ScaleBudget;