topic IF with a field containing multiple values in QlikView

IF with a field containing multiple values

Thu, 14 Jan 2010 13:48:31 GMT

There's a way to create a calculated variable linked to a condition starting from a field vector-like?

I.E. FIELD_CONDITION = 101,102,103 (this is an input object but this is not so important)

I want to put "A" for every record that have FIELD_SOURCE equal to one of the values in FIELD_CONDITION.

Obviously if I put this forumla: IF(FIELD_SOURCE=FIELD_CONDITION,'A','X')
QV resolve it in this way: IF('101'='101,102,103','A','X')

I wat something like this: IF('101'='101' OR '101'='102' OR '101'='103','A','X')

Thank you

Miguel_Angel_Baeyens — Thu, 14 Jan 2010 13:58:35 GMT

Hello,

You can use MATCH function so (untested)

IF(MATCH(FIELD_SOURCE,FIELD_CONDITION), 'A', 'X')

or even maps in load time using ApplyMap function.

Fri, 15 Jan 2010 08:47:28 GMT

MATCH function is perfect: IF(MATCH(FIELD_SOURCE,FIELD_CONDITION)<>0, 'A', 'X')

Thank you,
Bye