How do i bring up this logic in qlikview

[mohanrajsubrama]

Hi Folks ,

I have a requirement like below and I am wondering how to do it Qlikview.

I am having a table of data elements with different metrics in it with scores.

METRICID	ELEMID	Score
1052	101	100
1050	101	100
1048	101	94

And in another table I have Min and Max Threshold for these Metric Id's.I need to join these 2 based on Metric ID so I ll get 6 records with score in it.

Now for 1052 Metric :

if Alert =1001 then ErrorMin=0

if Alert=1001 then ErrorMax=99.98

if Alert =1002 then Warning min=99

if Alert =1002 then Warning max=99.99    This follows for remaining Metrics ID' s also.

Now my logic should be

if( score< = ErrorMax,'Error' ,

if (score>ErrorMax and score<=Warning max,'Warning'

if (score>Warning max,Passed)))

Could you guys please guide how can we achieve this in Qlikview..

METRICALERTLEVELDEID	ALERTLEVELID	METRICID	ELEMID	MAXTHRESHOLD	MINTHRESHOLD
1037	1001	1052	101	99.98	0
1038	1002	1052	101	99.99	99
1055	1001	1050	101	99.98	0
1056	1002	1050	101	99.99	99
1057	1001	1048	101	99.98	0
1058	1002	1048	101	99.99	99

Regards,

Mohan

[settu_periasamy]

Hi,

Do you already have the Second table (with Min and Max threshold), or do you want to create that table based on ALERTLEVELID?