Solved

[microwin88x]

Solved

[sunny_talwar · Accepted solution]

Try this:

Table:

LOAD ID,

    ATRIB

FROM

[https://community.qlik.com/thread/216855]

(html, codepage is 1252, embedded labels, table is @1)

Where Len(Trim(ID)) > 0;

ResultTable:

LOAD ID,

  If(WildMatch(Concat('|' & ATRIB & '|'), '*|55|*', '*|57|*'), 'Fail', 'OK') as Result

Resident Table

Group By ID;

[MarcoWedel]

Hi,

maybe also possible:

tabFailOK:
LOAD Dual(Result,RecNo()-2) as Result
INLINE [
    Result
    OK
    Fail
];

table1:
First 5
LOAD * FROM [https://community.qlik.com/thread/216855] (html, codepage is 1252, embedded labels, table is @1);

tabResult:
LOAD ID,
    not Min(ATRIB=55 or ATRIB=57) as Result
Resident table1
Group By ID;

hope this helps

regards

Marco