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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How do you match x, y coordinates for the interval in load scripts?

IntervalMatch - Two matching colums

The following script is not working in terms of matching correct data. can you please give me the reasons. The sample code is as follows

Basically i want to match x, y coordinates to find the count of defects in the scatter diagram. please help me.











T1:

Load

Measure.MeasureKey as mk

,

Measure.lensposx

as x

,

Measure.lensposy

as y

,

Measure.lensposx

+.05 as ux

,

Measure.lensposx

-.05 as lx

,

Measure.lensposy

+.05 as uy

,

Measure.lensposy

-.05 as

ly

Resident

Measure

where

Measure.MeasureKey

<50;

T2:



Load

Measure.MeasureKey as mk

,

Measure.lensposx

as x

,

Measure.lensposy

as

y

Resident

Measure

where

Measure.MeasureKey

<50;

T3:



IntervalMatch

(T2.x

)

LOAD

T1.lx,

T1.ux

Resident

T1;

Inner

Join

(T3)

IntervalMatch

(T2.y

)

LOAD

T1.ly,

T1.uy

Resident

T1;

Inner

Join

(T3)

LOAD

Count(T1.mk) as

defect

Resident

T1;





2 Replies
IAMDV
Master II
Master II

Please can you copy & paste the script again and make it readable? You can copy the script to notepad before posting here.

Cheers!

Anonymous
Not applicable
Author

The scripts are:

T1:
Load Measure.MeasureKey as mk,
Measure.lensposx as x,
Measure.lensposy as y,
Measure.lensposx+.05 as ux,
Measure.lensposx-.05 as lx,
Measure.lensposy+.05 as uy,
Measure.lensposy-.05 as ly
Resident Measure
where Measure.MeasureKey<50;

T2:
Load Measure.MeasureKey as mk,
Measure.lensposx as x,
Measure.lensposy as y
Resident Measure
where Measure.MeasureKey<50;

T3:
IntervalMatch(T2.x)
LOAD T1.lx,T1.ux
Resident T1;
Inner Join (T3)
IntervalMatch(T2.y)
LOAD T1.ly,T1.uy
Resident T1;
Inner Join (T3)
LOAD Count(T1.mk) as defect
Resident T1;