Calculated Field

[vardhancse]

Hi,

Have a requirement is that, need to create one field based on if condition.

Can any one let me know

[#2]

Hi,

Just create a list box, go to "General" sheet, find and open Field Combo Box and select "Expression" at the end of list, then you have to tip something like this:

If (Condition 1,

     Result1,

     Oposite Result

)

Example I need 1 if Sex Value is Male and 2 if is Female so I use:

If(Sex='Male',

     1,

     2

)

and if I have nulls I can use:

If( Sex = 'Male',

     1,

     If(Sex='Female',

          2,

          0 // To identify nulls values

     )

)

Best regards.

[pgrenier]

Hello Sasi,

Could you be more specific? Otherwise, you might want to check QlikView's help function by hitting the F1 key and entering "If" in the Index field.

Regards,

Philippe

[its_anandrjs]

Yes possible but please elaborate more which type of field or what condition you want to create the field.

[vardhancse]

requirement is that

in chart has written set analysis as =sum({<[Time]={'$(vMaxDate)'}>}[Field])

Let vMaxDate=MAx(Time)

sum(if(max(Time),(Field)) as Count