Discussion board where members can get started with Qlik Sense.
Please i need to create a new calculated field in my table , this field must retern YES or NO value
if(Field=100,'Yes','No')) as Temp
Creating a new field with IF statement | Qlik Community
thank you for your response Chanty 4u
What field and value you looking into to convert to YES and NO?
I want to create a new field that, depending on the value of other fields, it displays NO or YES
If: In this date: 'xx / xx / xxxx', IDOperation = 'A number' then This client has an operation this week: YES
If no>: NO
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
if(Datefield>= 'xx / xx / xxxx' and IDOperation='A number','YES','NO') as OperationFlag;
Field5 and so on....
Please check the syntax for above if condition.
Hope that works?
thanks you Aehman K !