Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Do you already have the Second table (with Min and Max threshold), or do you want to create that table based on ALERTLEVELID?