Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

khadija11
New Contributor II

create a new calculated field

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

7 Replies
sureshqv
Esteemed Contributor III

Re: create a new calculated field

try simple

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

sureshqv
Esteemed Contributor III

Re: create a new calculated field

khadija11
New Contributor II

Re: create a new calculated field

thank you for your response Chanty 4u

Khan_Mohammed
Honored Contributor II

Re: create a new calculated field

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

khadija11
New Contributor II

Re: create a new calculated field

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

Khan_Mohammed
Honored Contributor II

Re: create a new calculated field

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?

khadija11
New Contributor II

Re: create a new calculated field

thanks you  Aehman K !

Community Browser