Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Interval Match

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,

To

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.,

4 Replies
MayilVahanan

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,

To

Resident ScaleBudget;

Hope it helps,

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

no, it doesn't work

Miguel_Angel_Baeyens

Hi,

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

Hope that helps.

Miguel

chematos
Specialist II
Specialist II

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;