Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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
Luminary Alumni
Luminary Alumni

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;