topic Re: Interval Match in QlikView

Interval Match

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

Please find the Attached files.

How Can i use interval match in this two tables.

Maxmarks	Minmarks	Name
90	80	Raj
80	70	Raja
70	60	Varun
60	50	Venkat
50	40	Arun

Marks	Grade
85	A
75	B
65	C
55	D
45	E

Re: Interval Match

ajsjoshua — Thu, 19 May 2016 07:44:03 GMT

Hi,

PFA

Re: Interval Match

ajsjoshua — Thu, 19 May 2016 07:45:13 GMT

Hi,

table:

LOAD Name,

marks

FROM

E:\Joshua\sample\intervalmatch.xlsx

(ooxml, embedded labels, table is Sheet1);

table2:

LOAD Grade,

maxmarks,

minmarks

FROM

E:\Joshua\sample\int1.xlsx

(ooxml, embedded labels, table is Sheet1);

bridge:

IntervalMatch(marks)

LOAD maxmarks,minmarks

Resident table2;

Re: Interval Match

MK_QSL — Thu, 19 May 2016 07:46:19 GMT

Marks:
Load * Inline
[
  Maxmarks, Minmarks, Name
  90, 81, Raj
  80, 71, Raja
  70, 61, Varun
  60, 51, Venkat
  50, 40, Arun
];




Grade:
Load * Inline
[
Marks, Grade
85, A
75, B
65, C
55, D
45, E
];


Left Join 
IntervalMatch(Marks)
Load Minmarks, Maxmarks Resident Marks;


Left Join (Marks) Load * Resident Grade;


Drop Table Grade;

Re: Interval Match

MindaugasBacius — Thu, 19 May 2016 07:49:35 GMT

Intervals:
LOAD Maxmarks, 
     Minmarks, 
     Name
FROM

(ooxml, embedded labels, table is Sheet1);


Data:
LOAD Marks, 
     Grade
FROM

(ooxml, embedded labels, table is Sheet2);


IntervalMatch (Marks) LOAD Minmarks, Maxmarks Resident Intervals;

This might work.

Re: Interval Match

kkkumar82 — Thu, 19 May 2016 08:04:06 GMT

Hi Mahesh,

Beginners Task Series - Task3(Interval Match)

Hope this helps

Re: Interval Match

qlikview979 — Thu, 19 May 2016 08:07:42 GMT

Hi All,

Thanks for your Support.

Regards,

Mahesh.