# New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Not applicable

## Funciotion if with multiple values

Hi I nedd to create a new field to summarize information coming form another field saying:

- if (field A="1or2", then 'OK',

- if (field A= "3or4or5or6", then KO"

- if (field A= "7or8or9 then "MAYBE"

How can i put togheter?

Bruno

1 Solution

Accepted Solutions
Honored Contributor

## Funciotion if with multiple values

Hi Bruno, then put all numbers between 'x'. Like if(field A='1' or '2', 'OK'............

3 Replies
Honored Contributor

## Funciotion if with multiple values

Hi Bruno, this should work: If(field A=1 or 2, 'OK, if(field A = 3 or 4 or 5 or 6, 'KO', if(field A= 7 or 8 or 9, 'MAYBE'))) as new_field.

Not applicable

## Funciotion if with multiple values

are u sure If(field A=1 or 2 is working?

When i got just one value for category i write it as If(field A='1')

Honored Contributor

## Funciotion if with multiple values

Hi Bruno, then put all numbers between 'x'. Like if(field A='1' or '2', 'OK'............