create a new calculated field

[Anonymous]

Please i need to create a new calculated field in my table , this field must retern  YES or NO value

[Chanty4u]

try simple

if(Field=100,'Yes','No')) as Temp

[Chanty4u]

check here

Creating a new field with IF statement | Qlik Community

[Anonymous]

thank you for your response Chanty 4u

[MK9885]

What field and value you looking into to convert to YES and NO?

[Anonymous]

Hello ,

I want to create a new field that, depending on the value of other fields, it displays NO or YES

EX:

If: In this date: 'xx / xx / xxxx', IDOperation = 'A number' then This client has an operation this week: YES

If no>: NO

[MK9885]

Not sure but if all of your fields are in single table it would be much easier.

You can do preceding load with in the table to create a new field as below

Ex:

Table1:

Load*,

if(Datefield>= 'xx / xx / xxxx' and IDOperation='A number','YES','NO') as OperationFlag;

Load

Field1

Field2

Datefield

IDOperationField

Field5 and so on....

From....xls;

Please check the syntax for above if condition.

Hope that works?

[Anonymous]

thanks you  Aehman K !