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

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

Anonymous — Fri, 15 Apr 2011 10:19:27 GMT

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

Resident

Measure

where

Measure.MeasureKey

<50;

T2:

Load

Measure.MeasureKey as mk

Measure.lensposx

as x

Measure.lensposy

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;

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

IAMDV — Fri, 15 Apr 2011 10:21:18 GMT

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

Cheers!

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

Anonymous — Fri, 15 Apr 2011 11:39:45 GMT

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;