Discussion board where members can get started with QlikView.
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?
Thanks in advance
Go to Solution.
Hi Bruno, then put all numbers between 'x'. Like if(field A='1' or '2', 'OK'............
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.
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')