topic Re: Generate Value based on Codes in QlikView

Solved

microwin88x — Wed, 25 Nov 2020 16:16:04 GMT

Solved

Re: Generate Value based on Codes

sunny_talwar — Fri, 13 May 2016 16:17:31 GMT

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;

Re: Generate Value based on Codes

MarcoWedel — Mon, 16 May 2016 22:26:20 GMT

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